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 |
|
israelnyc
Starting Member
2 Posts |
 Posted - 2006-04-20 : 09:51:55
|
| I will be creating a scheduled backup job in SQL 2000. I am just unsure of whether SQL has to be shutdown during the backup for the backup to be successful (worried about open files).I appreciate any responses, Thank you. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-20 : 09:57:47
|
NO. You can still use and access the database while the backup is in operation
KH |
 |
|
|
israelnyc
Starting Member
2 Posts |
Posted - 2006-04-20 : 09:59:28
|
| Thank you khtan for your quick response. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-04-20 : 10:49:31
|
quote:
Originally posted by israelnyc
I will be creating a scheduled backup job in SQL 2000. I am just unsure of whether SQL has to be shutdown during the backup for the backup to be successful (worried about open files).I appreciate any responses, Thank you.
You cannot run a SQL Server backup while SQL Server is shutdown, and you cannot run a SQL Server job while SQL Server is shutdown.CODO ERGO SUM |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-20 : 11:04:49
|
"You cannot run a SQL Server backup while SQL Server is shutdown, and you cannot run a SQL Server job while SQL Server is shutdown."A very good point  unless your schedule job is the OS's schedule job and you just want to copy the MDF & LDF to backup devices
KH |
|
|
|
|
|
|
Database Backup - shutdown required?