Post reply

database offline/detach

  • May 25, 2005 at 1:43 pm

    #89264

    HI. Can someone explain to me the difference in taking a database OFFLINE and detaching a database? I have been using the detach/attach when I have had to move a transaction log file or had to delete a transaction log file. Can this process work with taking a database offline?

     

    Juanita 

  • May 25, 2005 at 1:50 pm

    #561085

    Detaching a database is almost equivalent to dropping the database with the exception of the data/log files not getting deleted. the entry in sysdatabases for the database name gets lost and you can create a new database which points to different files. SQL server no longer recognizes a detached database. Taking the database offline does maintain all the entries in the system tables and you won't also be able to create a database with the same name.

    On a different note, detach/attach is generally used for moving data files around or renaming files.

  • May 25, 2005 at 1:56 pm

    #561090

    Thanks so much !!!

    Juanita

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

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