Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL Interview Questions and Answers

Ques. How to set a database state to OFFLINE in MS SQL Server?
Ans. If you want to move database physical files, you should take the database offline by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name SET OFFLINE

The following tutorial example will bring "withoutbook" offline:

ALTER DATABASE withoutbook SET OFFLINE
GO

SELECT name, state_desc from sys.databases
GO
name state_desc
master ONLINE
tempdb ONLINE
model ONLINE
msdb ONLINE
withoutbook OFFLINE

USE withoutbook
GO
Msg 942, Level 14, State 4, Line 1
Database 'withoutbook' cannot be opened because
it is offline.
Is it helpful? Yes No

Most helpful rated by users:

©2020 WithoutBook