February 22, 2008 at 10:31 am
I am new to SQL and wanted to know what things should be done to a database to keep it in good shape. I just moved this database to SQL 2005. Any help and explainations would be appreciated.
Thanks
February 27, 2008 at 10:11 am
You can create a maintenance plan to do the task for you. you need to backup, reorganize index, reindex and these sort of tasks can be done easily with MP.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 27, 2008 at 10:47 am
use SQL Server 2005 Best Practices Analyzer tool to get more recommendations.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply