Monday, 23 February 2009

dbcc dbreboot

dbcc dbreboot

Options

_ report – Shows a report on the specified database(s).

_ reboot – Database is shutdown and restarted with recovery.

_ reboot_norecovery – Database is shutdown and restarted and left in

a “not recovered” state. Can be used to add more space.

_ shutdown – Database is shutdown and left in an unusable state.

_ shutdown_load – Database is shutdown and left in a state that

allows LOAD DATABASE to be done.

_ restart – Restart and recover a database that has been shutdown.

_ restart_norecovery – Restart database and left in a “not recovered”

state. Good when there are problems with recovery.

No comments:

Post a Comment