database offline/detach
-
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
-
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.
-
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