March 3, 2006 at 8:55 am
Has anyone seen this error before when doing a restore.
The file on device< backup folder\filename> is not a valid Microsoft Tape format set.
Any help will be greatly appreciated.
TIA
March 3, 2006 at 9:22 am
Can anyone please tell me what the below statement means.
SELECT @BkpString = 'RESTORE DATABASE [' + @RestoreDBName +
'] FROM DISK=N''' + @Bkpfile + ''' WITH FILE = 1, NOUNLOAD, RECOVERY, REPLACE,
MOVE N''ABC_DATA1'' TO N''' + @DataFolder + @DBName + '.mdf'',
MOVE N''ABC_DATA2'' TO N''' + @DataFolder + @DBName + '_1.ndf'',
MOVE N''ABC_LOG'' TO N''' + @LogFolder + @RestoreDBName + '_log.ldf'''
Any help will be greatly appreciated...
March 6, 2006 at 11:10 am
This command is simply building a restore string. After this is run you can run the restore string by running exec sp_executesql @bkpstring
I personally do not like running sql this way and would rather simply run the restore string in query analyzer.
As for this error, this means that the backup file is of a format other than what sql server can restore. Is it possible that this backup was created with a third party backup utility like netbackup or litespeed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply