Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pucci70
Starting Member
20 Posts |
 Posted - 2002-07-30 : 10:32:00
|
| What is the difference between detaching a database and taking it offline? Which option it is better in order to make the upgrade from 7 to 2000? Grazie-----------------Good Work! |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-30 : 11:16:00
|
| Taking the database off-line is similar to closing a file. However the database is still known by and belongs to the instance.Detaching a database is like both closing the database files and removing knowledge of it from the instance.Detaching a database makes sure all "dirty pages" get written out first. That the database is "complete".A database detached from SQL 7 can be attached to SQL 2000. This process will convert the SQL 7 database. So once this is done, you can not detach the database from SQL 2000 and re-attach it to SQL 7.HTHs solart |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-07-30 : 11:17:34
|
When you take your database offline it is not accessible by users, but the server keeps track of the database (such as database name, path to data and log files). When you detach your database, all references to it are deleted (SQL Server becomes completely unaware that this database ever existed), so it is completely safe to move datafiles to a different location, or delete them. If you are upgrading by setting up a new server, you will need to copy data and log files, which means you should detach database.Sniped!  Edited by - izaltsman on 07/30/2002 11:18:33 |
|
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-30 : 12:07:29
|
| Clear (or clearer) explanations should always be appreciated.Thanks izaltsmansolart |
|
|
|
pucci70
Starting Member
20 Posts |
Posted - 2002-07-31 : 04:51:21
|
| Thanks a lot!-----------------Good Work! |
|
|
|
|
|
|
Difference between detaching and offline