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.
Artikel Terkait
SQL SERVER � SQL Error � Msg 7399, Level 16, State 1, Line 1. The OLE DB provider "SQLNCLI" for linked server "(null)" reported an error. Authenticati | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* St
SQL SERVER � Server Configurations Options � Agent XPs Option | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* St- SQL SERVER � Working with LSN for Restore and Backup Databases. (Error: Msg 4305, Level 16, State 1, Line 1) | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* Fo
- SQL SERVER � Error: Property Owner is not available for Database '[DB_NAME]'. This property may not exist for this object, or may not be retrievable | Backup Server Tips Normal 0 false false false MicrosoftInternetExplorer4 !-- /* St
EmoticonEmoticon