Post reply

Offline file group

  • July 25, 2011 at 2:13 am

    #241992

    Hi ,

    Why we need to take a particular file to offline. In what scenario MS has introduced this concept. And where can we use this in typical business scenario.

  • July 25, 2011 at 2:18 am

    #1357635

    Lookup MSDN

    http://msdn.microsoft.com/en-us/library/bb522469.aspx

    OFFLINE

    Sets the file offline and makes all objects in the filegroup inaccessible.

    Caution note Caution

    Use this option only when the file is corrupted and can be restored. A file set to OFFLINE can only be set online by restoring the file from backup. For more information about restoring a single file, see RESTORE (Transact-SQL).

    Jayanth Kurup[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply