September 12, 2009 at 7:40 am
Hi Experts
this is regarding i have 200 gb of database , and the ' D' drive was 120 gb , and the data base in the full recovery model, and daily there is lot of data updation and trancastions is going , here my data fileis 1.9 gb, and LOG is 40 gb, daily i am taking the back up and it will be 1.9 gb , i am taking the backup for the daily from past 45 day so the space in the drive get conjested and it came back to 6 gb , if i take for three more day it will finish.
but i cant delete the backup because the solution was not yet given to the client. the needed.
is there any think i can do on the log file to decrese,
I already shrink the log file once it gives 2 gb , by doing this shrinking it will make any problem?
please help me out ,please guide ,
please provide any Link, any soure of guide
Regards
sat
September 12, 2009 at 11:50 pm
You could do worse than read:
http://msdn.microsoft.com/en-us/library/ms345382.aspx
and
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
September 13, 2009 at 6:44 am
You should go through the articles that Paul pointed you to read.
It seems your database is in full recovery mode. Are you taking regular log backups?
If recovery to point in time is not required, you can switch to simple recovery mode to avoid managing log files.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply