What is T-SQL Script to Take Database Offline – Take Database Online?

-- Take the Database Offline

 ALTER DATABASE [myDB] SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO

 -- Take the Database Online

 ALTER DATABASE [myDB] SET ONLINE
GO
By -
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...