March 15, 2006 at 10:26 am
I am having problems restoring a backup file created by sql litespeed. I am using
EXEC master.dbo.xp_restore_database @database='checktemp',
@filename='d:\aaa.bkp',
@with='MOVE "aaa_DATA1" TO "D:\mssql\CAPS\data\checktemp.mdf"',
@with='MOVE "aaa_DATA2" TO "D:\mssql\CAPS\data\checktemp_1.ndf"',
@with='MOVE "aaa_LOG" TO "D:\mssql\CAPS\log\checktemp_log.ldf"',
@with='RECOVERY', @with='REPLACE'
its works for a bkp file which doesnt have a data but if i try to restore a backup which has soem data it fails with error as
The file 'd:\aaa.bkp' is not a SQL LiteSpeed backup.
Enter the correct path and name of the backup file. Both the bkps that are tried is on same location only diff is one is empty the other is not. any help will be greatly appreciated.TIA
March 15, 2006 at 11:00 am
Hello Ishaan,
I took a test backup with data through SQL Litespeed and restored back successfully. I have used the normal restore syntax and executed in QA.
restore database [Test1]
from DISK= N'D:\MSSQL\Test200603151229.BKP'
with FILE = 1, NOUNLOAD, STATS = 10, RECOVERY,
MOVE N'Test_Data' TO N'I:\Data\Test1_Data.mdf',
MOVE N'Test_Log' TO N'T:\Logs\Test1_Log.ldf'
Lucky
March 15, 2006 at 11:23 am
Thanks Lucky but i tried what you had sent and this is what i get.
The file on device 'd:\aaa.bkp' is not a valid Microsoft Tape format backup set.
Restore database in terminating abnormally.
any clue on this??
TIA
March 15, 2006 at 12:00 pm
LiteSpeed has a command line utility which can expand a Lightspeed backup into a "normal" SQL Server backup. If you use it, is it able to read the backup file properly and expand it? Is the restore failing on all LiteSpeed backups or just the one?
K. Brian Kelley
@kbriankelley
March 15, 2006 at 12:02 pm
I tried both with xp_restore_database (where litespeed dll is used) and also with restore database but none works. works well for a .bkp file which is empty i mean no data but not for one which has data. any suggestions please?
March 16, 2006 at 10:01 am
Ishaan99,
Is there any reason why are not using SQL Litespeed's GUI enterface for the restore and have you tried it?
Jules Bui
IT Operations DBA
Backup and Restore Administrator
March 16, 2006 at 11:48 am
couple of points:
You made the original backup with SQL LiteSpeed, right?
We usually use extension LBK for LiteSpeed backups and are not using @with='RECOVERY' option for restore.
Also you might want to use verify option next time you will perform a backup.
March 20, 2006 at 9:00 am
Brasuk - Although its a Litespeed backup i have the file savd as .BKP so how will it take the file name correctly if i use .LKP.
Jules - No i havent used the gui interface of sql litespeed for the restore..
March 20, 2006 at 9:04 am
Ishaan99,
Is there a reason not to use the SQL Litespeed GUI?
Jules Bui
IT Operations DBA
Backup and Restore Administrator
March 20, 2006 at 9:09 am
No its just that i dont know know how to use. i tried a restore from EM which didnt work. Here backups are taken by a different team of people so never tried using using Litespeed GUI. But what i feel strange when it works for a .BKP which is empty why cant it work for one which has got some data in it?
March 28, 2006 at 6:30 pm
Ishaan99,
Hello, I happen to work with Quest in support around the LiteSpeed product, and I think I can help get this issue squared away with a quick walkthrough over the phone! If you would, could you to shoot me your contact information to robert.boule@quest.com I am confident we can work this out in very short order!
Thank you for your time, I look forward to speaking with you!
Bob
January 28, 2009 at 4:19 pm
I know the thread is old but could others find out about this fix if there is one, I am having the same issue.
January 29, 2009 at 8:55 am
Simplest answer? Use their knowledge base or call their support line. If it was opened as an issue 3 years ago, chances are good they'll have a resolution on their KB. I've used the product for several years and never had an issue like this.
-- You can't be late until you show up.
January 29, 2009 at 8:58 am
Well I found the root of my issue when I ran the backup besides outputting to the file I designated in my script litespeed also wrote stripes to two different drives so I exported the .bak file I designated in the script and not the other hence my problem. Thanks.
January 29, 2009 at 9:01 am
Glad you solved your issue! 😉
-- You can't be late until you show up.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply