Mohammad Nazmul Huda
Search this site
About Me
Certifications
Employment History
Publications
Study Resources
Training
Technical Docs
Oracle
Managing Database
Backup and Recovery
Performance Tuning
ASM
Security
Replication
Database Change
Data Guard
Cloud Control
LISTENER
Parameters
SQL
SQL Functions
PL/SQL
ORA ERROR
12c Issues
Bugs
Scripts
Tools
OCM
Teradata
MySQL
SQL SERVER
Linux
AWS
Data Science
Other
Contact
How to Take Database Offline and Bring it to online in SQL Server Database
Using T-SQL Command:
Take Database Offline:
ALTER DATABASE [Sales]
SET offline WITH ROLLBACK IMMEDIATE;
Bring Database Online:
GO
ALTER DATABASE [Sales] SET online;
Comments