Help with Backup and Restore

The online Backup and Restore Troubleshooter is designed to help you resolve problems you may encounter when backing up or restoring databases and transaction logs in Microsoft® SQL Server™ 2000.

Note  For international users of SQL Server Books Online, the text of the problems as well as the references to Knowledge Base articles appear in English and can be found on nonlocalized Web sites.

Common starting points for troubleshooting backup and restore include:

• Problems with backing up or restoring a database or transaction log that is password protected.
  
  
• Problems appending or initializing a backup to an existing backup device.
  
  
• Problems when backing up a transaction log or performing a differential file or file group backup while the database is set to the 'SIMPLE' recovery mode.
  
  
• Poor performance when performing a backup or restore.
  
  
• The database restore completes successfully, but the backup appears to have restored the database to a point in time earlier than expected.
  
  
• Problems performing a point-in-time restore of a transaction log.
  
  
• System database backups cannot be restored on a different build of SQL Server.
  
  
• Error 927 when attempting to use a database after a successful restore.
  
  
• Error 3201.
  
  
• Error 3203.
  
  
• Error 3024.
  
  
• Error 3038.
  
  
• Error 3101.
  
  
• Error 3108.
  
  
• Error 3168.
  
  
• Error 3141.
  
  
• Error 3159.
  
  
• Error 4330.
  
  
• Errors 1834 and 3156.
  
  
• Errors 4326 and 4305.

To access troubleshooters online, see Viewing Online Troubleshooters and other PSS Web-Based Information.