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

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

What is SQL Injection in SQL Server ?

Adding Columns to a Table with a Query in MS SQL

What is Service Broker in SQL Server ?

Which TCP/IP Port Does the SQL Server Run On ?