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 |
|
CLages
Posting Yak Master
116 Posts |
 Posted - 2005-06-16 : 08:04:15
|
| hi allwe have an aplication with around 100 Users, If the Backup is fired with the users running the aplication , what does backup will do ?It will Hold all transaction until backup ends?will it backup anyway ?I will get some Erros?I did not see any information in BOL with this situation.TksCLages |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-16 : 08:49:17
|
| Straight from the BOL Backup Article:"RemarksDatabase or log backups can be appended to any disk or tape device, allowing a database, and its transaction logs, to be kept within one physical location. SQL Server uses an online backup process to allow a database backup while the database is still in use. The following list includes operations that cannot run during a database or transaction log backup: File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE options; INSERT, UPDATE, or DELETE statements are allowed during a backup operation.Shrink database or shrink file. This includes autoshrink operations. If a backup is started when one of these operations is in progress, the backup ends. If a backup is running and one of these operations is attempted, the operation fails."Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
|
|
|
what happens if the Backup is started with