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 |
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2006-06-14 : 10:56:46
|
Hey guys,Is there a way to perform a offline backup of SQL Server 2000 databases?Kleber |
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-06-14 : 11:57:17
|
What is your deffinition of "offline"? |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2006-06-14 : 13:17:38
|
Offline means exactly to be impossible to have any user logged in the database. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-14 : 13:24:30
|
Why do you want that?CODO ERGO SUM |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2006-06-14 : 13:29:17
|
We are migrating a very sensitive database from a server to another. We will do that using a backup. So I have to ensure that the database will not have any kind off access during the backup procedure. That's why I need to know if there is a way to perform a backup with the database offline.Regards |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-14 : 14:04:26
|
Just set the database to read only and restricted user, and then run a regular backup.CODO ERGO SUM |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-14 : 14:09:51
|
There are two ways to do an offline backup:1. stop the SQL Server service, copy the MDF and LDF files to another location, start the service (plus the agent)2. detach the database, copy the MDF and LDF files to another location, reattachI almost never perform an offline backup. I do online backups using a similar method to Michael's suggestion.Tara Kizeraka tduggan |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2006-06-14 : 14:19:16
|
Thanks a lot. I will use Michael's suggestion. |
|
|
|
|
|