Thursday, February 16, 2012

After Recovery...

Is it required/best practice to run any job/commands after restoring the SQL
database server? SQL2K.
Thank you for the answers.
AustinHi,
You can execute a DBCC CHECKDB('dbname') to confirm the database is in good
shape. As well as you can schedule
a UPDATE STATISTICS weekly once or daily (depends on the data size).
Thanks
Hari
SQL Server MVP
"JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
> Is it required/best practice to run any job/commands after restoring the
> SQL
> database server? SQL2K.
> Thank you for the answers.
> Austin
>
>|||Thank you,
Austin
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239dgfUPrFHA.1172@.TK2MSFTNGP11.phx.gbl...
> Hi,
> You can execute a DBCC CHECKDB('dbname') to confirm the database is in
good
> shape. As well as you can schedule
> a UPDATE STATISTICS weekly once or daily (depends on the data size).
> Thanks
> Hari
> SQL Server MVP
>
> "JohnSmith" <JJSmith_Austin@.hotmail.com> wrote in message
> news:e7npwNPrFHA.2996@.tk2msftngp13.phx.gbl...
>

No comments:

Post a Comment