What are OFFLINE Datafiles with SQL Server ?

The OFFLINE directive is a new feature of the ALTER DATABASE command. This allows databases that employ multiple filegroups to be online serving queries, while some of the database data may unavailable, in one or more filegroup(s) marked as offline.



You May Interest

What is Blocking in SQL Server ?

Deleting Columns From a Table with a Query in MS SQL

How to Rebuild the Master Database in SQL Server ?

What is an Online Rebuilding of Indexes in SQL Server ?

Disabling a Specified Trigger in MS SQL Server