LiteSpeed Restore Database (NON-WIZARD) errors when restoring multiple NATIVE transaction logs.
SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding.....
....RESTORE LOG is terminating abnormaly.
The media family on device 'D:\MSSQL.1\MSSQL\Backup\Logs\backup...11070721435.trn' is incorrectly formed. SQL Server cannot process this media family.
WORKAROUND:
1. Use the LiteSpeed RESTORE DATABASE WIZARD in Enterprise Console
2. Run t-sql script in Query Analyzer
Fixed in version 4.8.4.x of LiteSpeed
Example of entire restore script:
Use master
goexec master.dbo.xp_restore_database @database = 'Northwind', @filename = 'D:\Backup\Northwind200611170550Full.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD'
exec master.dbo.xp_restore_log @database = 'Northwind', @filename = 'D:\Backup\Northwind200611170552Trans.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD'
exec master.dbo.xp_restore_log @database = 'Northwind', @filename = 'D:\Backup\Northwind200611170555Trans.BKP', @filenumber = 1, @with = 'RECOVERY', @with = 'NOUNLOAD', @with = 'STOPAT = N''2006-11-17 05:54:10'''
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center