Backup Restrictions
Using SQL Server, backup operations can occur while the database is online and in use. However, the following operations are not allowed during a database backup operation:
- Creating or deleting database files
- Creating indexes
- Performing non-logged operations
- Shrinking either the database (automatically or manually) or the database files
If a backup operation is started when one of these operations is in progress, the backup operation terminates. If a backup operation is in progress and one of these operations is attempted, the operation fails and the backup operation continues.
Copyright © 2005 Microsoft Corporation.
All rights reserved.