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 (https://blog.sqlauthority.com)
5 Comments. Leave new
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.