About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
Can an SQL database be restored to a different platform and/or SQL Server version?
Answer
The cross-platform restore functionality is based on the capability of the Microsoft SQL Server.
As noted at the following Microsoft link:
- SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms191253(v=sql.100).aspx
- SQL Server 2012: http://msdn.microsoft.com/en-us/library/ms191253.aspx
This type of alternate restore is only possible with user databases, not the databases used by the SQL Server itself, such as master, msdb, etc.
It is important to note that the backups can only be restored to the same or newer version of the SQL Server. Also, as referenced in the Microsoft documents, the SQL Server backup and restore works across supported operating systems, whether they are 64-bit or 32-bit systems.
It is necessary to ensure that the Data Protection for SQL version used for the restore is the same (or newer) version then was used for the backup. For example if the backup was performed with the Data Protection 6.4 client, the restore can be performed with 6.4 or the version 7.1 Data Protection software. You cannot perform the restore with the 6.3 release.
[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for MS SQL","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Product Synonym
TSM
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager for Databases
Software version:
Version Independent
Operating system(s):
Windows
Document number:
489949
Modified date:
17 June 2018
UID
swg21634501