April 7, 2010 at 10:02 am
Hi All experts,
We have a SQL Server 2000 database in production server. Our transaction log files are saved on separate drive. But a disk is getting full, So my question is can I set a Auto Shrink enable for all the database in Production? Is it ok to do Auto Shrink enabled for the performance point of view? Will it hurt to data or log file or anything in Production database ? Any otherway to resolve it?
I would be appreciate for your feedback asap.
Thanks,
K
April 7, 2010 at 10:30 am
Hi K,
If you the db is a Prod db and if you are using Full Recovery Model (which I think should be) then configure hourly Transaction log backups or set the frequency of Log backups based on your environemnt.
Its not a good option to enable Autoshrink option for the db because it causes fragmentation and results in performance issues.
Instead you can create Shrink Log Job which can shrink the TLog on daily basis or more frequently based on your need.
Thank You,
Best Regards,
SQL Buddy.
April 7, 2010 at 10:35 am
Don't use auto shrink in production
http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx"> http://www.sqlskills.com/blogs/paul/post/Auto-shrink-e28093-turn-it-OFF!.aspx
April 7, 2010 at 11:45 am
Thanks for your reply..
April 7, 2010 at 11:45 am
Thanks for your reply..
April 7, 2010 at 11:45 am
Thx...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply