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 are Sparse Columns in SQL Server ?

What is Data Collector in SQL Server ?

Changing Column Name of MS SQL Table with Query

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

Using MS SQL TOP