SQL SERVER � SQL Daily Tip � Force Database Offline. | Backup Server Tips

SQL SERVER � SQL Daily Tip � Force Database Offline. | Backup Server Tips

1:40:00 AM

To force a database to bring OFFLINE you can use the next statement:



alter database DBNAME set offline with rollback immediate



this is a quickly way to force a database to set it OFFLINE, when you use this statement a rollback occurs for all the transactions running.

ramanaptr

Artikel Terkait

Next
« Prev Post
Previous
Next Post »
Subscribe to: Post Comments (Atom)