Home Forums SQL Server 2008 SQL Server 2008 Administration DBA task for large production database RE: DBA task for large production database
KumarVelayutham
SSCrazy
Points: 2204
More actions
October 8, 2012 at 2:32 am
#1546600
Check the following factors are considered or not?
1.Database size and growth should be mentioned initially.
2.Check the unused index and drop the unused index.
Then set up your maintenance plan for backup,dbcc reindex,etc
Regards,Kumar