June 29, 2010 at 3:56 am
When i take backup on a database for by executing following statement:
BACKUP DATABASE [test] TO DISK = N'\etworkpath\SQLBackup\test.bak' WITH NOFORMAT, NOINIT, NAME = N'test', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
It is generating two files one with .bak and one with .bak.lsi. extensions like test.bak and test.bak.lsi and when i try to restore the test.bak file it is giving error.
Can any one please help me asap, how would i restore and how can avoid having two files while backup.
FYI we lite speed running on this server.
Thanks for all the help.
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 29, 2010 at 6:11 am
That's not a normal issue, but evidently it's happened before[/url]. It sounds like you must have some third party software involved with your backups, possibly interfering in the backup process itself, which is why your backup files are corrupt.
Are you running this software?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 29, 2010 at 6:17 am
Thanks for the response :-), Yes we are using Lite speed as backup software and it is the cause for the issue. I think we need to speak to Light speed people for work around and we are going to talk to them.
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 29, 2010 at 6:20 am
It sounds like you might have an issue with the Litespeed install. Instead of trying to run the standard backup & restore commands, try using Litespeed's extended stored procedures. You might see a difference.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 29, 2010 at 6:39 am
I think it is because, i was trying to restore the backup file on the new server where we don't have lite speed installed, now we have installed and able to restore database.
Thanks,
Nagesh S
Nag
------------------------------------------------
How to get the best help on a forum
http://www.sqlservercentral.com/articles/Best+Practices/61537
June 29, 2010 at 6:46 am
Nagesh S-432384 (6/29/2010)
I think it is because, i was trying to restore the backup file on the new server where we don't have lite speed installed, now we have installed and able to restore database.Thanks,
Nagesh S
That would do it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply