I have been receiving following question again and again either through email or through comments on this blog.
My log file is too big, what should I do?
Answer to this question is in three steps.
- Backup the log file to any device.
- Truncate the log file.
- Shrink the log file.
I have previously written two article about this issue. Refer them for additional information and details.
SQL SERVER – Shrinking Truncate Log File – Log Full(Script)
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2(Management Studio)
Reference : Pinal Dave (http://blog.SQLAuthority.com)
How to shrink the database not the the log file
Best regards
Sayed
Saudi Arabia
Hi My Database log file is large so finding a data from database it is very slow the result of output getting.
so what i should do?
And second problem is whenever multiple user upload data on that server that time web site is not running i.e. error is generate server unavailable application.so what is the reason…?
how can we backup one datafile and restore it in another server ?
is it possible?
To MohammadReza:
Yes it is possible, just restore it as you would in any normal database. Just make sure you do have a database to restore it to.
Hi,
Can you please suggest me on the below.
I want to set up the notification whenever my t-log is full.
can we use a script for automatically shrinking the log file.
[...] SQL SERVER – Solution – Log File Very Large – Log Full What do you do when your log is too full. This blog contained a quick advice, when I look at it back, I feel to add many more disclaimers to my own article. Well, I was beginner in the field and we all learn. Well, today I have opportunity so I am adding one disclaimer here – use the advice with care and always take full backup if you are not sure what you are doing. Rather do not do anything if you are not sure what you are doing – consult who know what they are doing. Production server is not something one should take chances with. [...]