May 12, 2009 at 12:41 am
1. A DBCC SHRINKDATABASE statement referencing reduced data file and log file size.
2. A DBCC SHRINKFILE statement referencing a log file to empty logfile .
One of the production server, 2 weeks back i have executed dbcc command shirnkfile for reduced log file size, before log,log2 file size 52 GB after executed DBCC SHRINKFILE (logfilename, 64) both log file becomes 64 KB. it was working fine. then i take Tlog backup every 1 hours daily.
But i have doubt for reducing lofile should be use DBCC SHRINKDATABASE command, so instead of this command i have used DBCC SHRINKFILE statement. please tell me , is there goging to worng in production database in future?.
Thanks
May 12, 2009 at 1:03 am
Shrink db will reduce the size of data and log files. Shrink file can be used to target specifically the data or log files.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply