June 3, 2008 at 4:05 pm
On MS SQL Server 2000, I could adjust DB properties and run a shrink that would shrink my log files. Is there a way to do this in 2005? I have a log file that is just getting enormous and we want to start it over again but I can't figure out how to do it??
Thanks!
~mj
June 3, 2008 at 7:15 pm
right click the database--> tasks--> shrink--> files
or DBCC SHRINKFILE http://support.microsoft.com/kb/907511
June 3, 2008 at 9:30 pm
Jones,
Take a transaction log backup and shrink the log file. Regular shrinking is not advisable as it causes fragmentation. Refer this link for more info,
http://www.sqlservercentral.com/Forums/Topic508854-357-1.aspx
[font="Verdana"]- Deepak[/font]
June 3, 2008 at 10:17 pm
In sql server 2005 we can do this.
backup log db to disk=' '
DBCC SHRINKFILE (db,800) WITH NO_INFOMSGS
I did like this it worked.Try this.
June 4, 2008 at 9:01 am
Hi Michelle,
In SSMS right click the DB, select Properties then Options - Recovery model is second field from the top.
Cath
June 4, 2008 at 12:53 pm
Thank you Cath. I feel like a fool as I finally found that. I knew it was pretty easy but I was just overlooking it and it was driving me nuts!! 🙂 Thanks to all for suggestions and help! 😀
~mj
June 4, 2008 at 7:02 pm
Deepak (6/3/2008)
Jones,Take a transaction log backup and shrink the log file. Regular shrinking is not advisable as it causes fragmentation. Refer this link for more info,
http://www.sqlservercentral.com/Forums/Topic508854-357-1.aspx
"Regular shrinking is not advisable as it causes fragmentation. " ---> Does this apply to transaction log file?
June 4, 2008 at 7:13 pm
Read through this link which describes the impact of regular shrinking,
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
[font="Verdana"]- Deepak[/font]
June 4, 2008 at 7:45 pm
Thank you. Great info! Worth rereading.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply