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 |
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
 Posted - 2006-11-15 : 07:07:16
|
| Can anybody tell, what is the difference between Backup - Restore and Attach - Deattach DB? what is the difference between them?Mahesh |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-11-15 : 07:13:03
|
| The main difference from an end-user point of view is that detach-reattach requires a database outage.-------Moo. :) |
 |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-11-15 : 07:26:35
|
quote:
Originally posted by mr_mist
The main difference from an end-user point of view is that detach-reattach requires a database outage.-------Moo. :)
I will be very thankfull Mr.Mist, if u will explain in deep.Thanks again,Mahesh |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-11-15 : 07:36:46
|
| Its means that if you are deattaching the database, then no user will be able to access that database. the database is out the server then. You again have have attach the database for the users to able to access that. Where as in the backup-restore database, the database is on the server itself and no user are disconnected from it. Normally when you migrate the database from the production server to the test server, you do backup restore database. so no user are affected in any ways. Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
|
|
Attach - Deattach v/s Backup - Restore