Where all SQL error messages are stored

Error messages when backing up the database (Restore)

"Operating system error 5 Access denied - backup medium cannot be opened"

The SQL server that performs the backup runs in its own "Network Service" user account and therefore does not have the necessary access rights for the desktop or the "My Documents" of the logged-in user by default.

Remedy: Store the * .bak file in the "public documents" or similar in order to read it in from there, or in a new directory C: \ Backup or similar, including USB sticks and the like. are unproblematic.

To avoid this problem and to make restoring easier, the account in which the relevant SQL server service is running can be changed to the local system account (screenshot on the right).

"Error while searching directory - the system cannot find the path specified"

Activate With path (MOVE) and repeat the process.

If that does not help: perform the recovery using the Microsoft SQL Server Management Studio:

  1. Start Microsoft SQL Server Management Studio and log into the desired SQL server,
  2. Open the "Databases" node,
  3. Select the database to be restored, right-click on "Tasks",
  4. Select "Recovery"> "Database",
  5. "Source": select "Medium",
  6. Select the file with the data backup (use the "..." button to the right of the text field),
  7. Switch to "Options" and checkbox "Overwrite existing database"activate,
  8. Start restore.

See also:

Upward and downward compatibility

Data backups are downward compatible, but not upward compatible. It is therefore not possible to import the backup from a newer SQL server into an older SQL server.

Older data backups can usually be read into a newer SQL server version. However, a restore from 2000 to 2012 ends: The SQL Server 2012 cannot read a 2000 backup (version number 8.x). In order to read a 2000 backup into a 2012 server or higher, the 2000 backup must first be read into a 2005, 2008 or 2010 SQL server and a new data backup created from it.

Remedies:

  1. Temporary installation: a 2005, 2008 or 2010 SQL server is temporarily installed using the setup wizard, "Login" window. The data backup is read into this. If a data backup is then created again from this, it can also be read by higher versions.
  2. If version 2010 of the SQL server can be installed, there is nothing to prevent it from simply using it, then the restore is unproblematic

"SQL Server cannot handle this media family."

Error # -2147217900: The media family on media ... is invalid. SQL Server cannot process this media family.

Appears when you try to read the backup from a SQL Server 2008 into a SQL Server 2005.

In order to work with the data from the data backup file despite such error messages, the SQL Server should be switched to the version from which the data backup originates.

"Cannot save more than 64 databases."

Error # -2147217900: Unable to save more than 64 databases ...

Appears when you try to read the backup from a SQL Server 2008 or 2005 into a SQL Server 2000.