Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 6.5 Backup - shutdown
- Thread starter sukip
- Start date
In Microsoft SQL Server, backup operations can occur while the database is online and in use. However, some operations are not allowed during a database backup:
Creating or deleting database files.
The file truncation portion of a shrink operation on either the database (automatically or manually) or the database files. They will fail if a backup is running. You can perform the truncation after the backup completes. For more information, see Shrinking a Database. (in books on-line)
If a backup is started when one of these operations is in progress, the backup waits for the operation to complete, up to the limit set by the session timeout. If a backup is in progress and one of these operations is attempted, the operation fails and the backup continues.
Creating or deleting database files.
The file truncation portion of a shrink operation on either the database (automatically or manually) or the database files. They will fail if a backup is running. You can perform the truncation after the backup completes. For more information, see Shrinking a Database. (in books on-line)
If a backup is started when one of these operations is in progress, the backup waits for the operation to complete, up to the limit set by the session timeout. If a backup is in progress and one of these operations is attempted, the operation fails and the backup continues.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
