Can a LiteSpeed backup, created on a SQL Server 2000 be restore to a SQL Server 2008 R2 ?
In SQL Server 2008, you can restore a database backup that was created by using SQL Server 2000, SQL Server 2005, or SQL Server 2008. However, backups of master, model and msdb that were created by using SQL Server 2000 or SQL Server 2005 cannot be restored by SQL Server 2008. Also, SQL Server 2008 backups cannot be restored by any earlier version of SQL Server. SQL Server backup and restore work across all supported operating systems, whether they are 64-bit or 32-bit systems. |
See : http://msdn.microsoft.com/en-us/library/ms191253.aspx
Additional Information:
If this is not successful, the Extractor Utility returns the backup file to a native format, which may be restored using SQL Server Restore Database tools.
The Extractor utility is located at:
...\Program Files\Imceda\LiteSpeed\SQLServer\Extractor.exe
In more recent versions of LiteSpeed, it is located at: ..\Program Files\Quest Software\LiteSpeed\SQL Server\Extractor.exe
Example from command line (-F is the source file and –E is the destination):
extractor.exe -Fc:\Backup\Northwind.bak -Ec:\Backup\NorthwindNative.bak -N1
Note: If your backup file in the SQL Server default backup folder, you'll need to put double quotes around the path parameter due to the space in the folder name 'Program Files'.
Example: extractor.exe -F"C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\\Northwind.bak" -Ec:\Backup\NorthwindNative.bak -N1
The LiteSpeed backup process may have been run with multiple threads, this results in a series of files when extracted. These files are restored with the native commands as a striped backup.
The Extractor Utility returns the backup file to a native format, which may be restored using SQL Server Restore Database tools.
The Extractor utility is located at:
...\Program Files\Imceda\LiteSpeed\SQLServer\Extractor.exe
In more recent versions of LiteSpeed, it is located at: ..\Program Files\Quest Software\LiteSpeed\SQL Server\Extractor.exe
Example from command line (-F is the source file and –E is the destination):
extractor.exe -Fc:\Backup\Northwind.bak -Ec:\Backup\NorthwindNative.bak -N1
Note: If your backup file in the SQL Server default backup folder, you'll need to put double quotes around the path parameter due to the space in the folder name 'Program Files'.
Example: extractor.exe -F"C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\\Northwind.bak" -Ec:\Backup\NorthwindNative.bak -N1
The LiteSpeed backup process may have been run with multiple threads, this results in a series of files when extracted. These files are restored with the native commands as a striped backup.
RESTORE DATABASE Northwind
FROM DISK='d:\backup\NorthwindNative.bak0',
disk='d:\backup\NorthwindNative.bak1',
disk='d:\backup\NorthwindNative.bak2'
WITH RECOVERY
For additional information regarding Extractor Utility, please refer to the LiteSpeed help file using the keyword: Extractor.
