Backup Restrictions

  • Article

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.