November 8, 2010 at 3:27 pm
I'm trying to determine if I should schedule my database reduce job to run every friday since it's currently done manually, but I'm not sure if that's the best practice. any suggestion as to the best practice will be appreciated.
Thanks.
November 8, 2010 at 3:59 pm
By database reduce job do mean that you are shrinking the DB?
November 8, 2010 at 7:20 pm
Yes.
November 8, 2010 at 7:42 pm
You should not be shrinking the database on a regular basis. That is something put in there for emergencies, or one time events, not regular maintenance.
This can cause a lot of fragmentation and slow down queries in your database.
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/13/629059.aspx
November 8, 2010 at 7:48 pm
Thanks. I'll heed to your advice!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply