March 24, 2008 at 10:00 pm
Hi, On my SQL SERVER 2005 /SP2, I took a 70Gb backup to diffrent 20 files to for copying it to DRP Server which is almost 3000 Miles from prod server. Every Thing went fine adn now i am in the process od restoring the backup files
BUT Getting This Error :
Msg 3227, Level 16, State 1, Line 1
The backup media on "G:\Backup\PROD2.BAK" is part of media family 2 which has already been processed on "G:\Backup\PROD5.BAK". Ensure that backup devices are correctly specified. For tape devices, ensure that the correct volumes are loaded.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
This is Really Critical , Any help willbe appritiated.
March 25, 2008 at 12:36 pm
Can you post the scripts you used to do the backup, and the scripts you are using to try the restore?
The Redneck DBA
March 29, 2008 at 4:15 pm
I am sure, you are using wrong file names.
I will suggest you run following script on server where you performed backup:
select 'disk = ''' + physical_device_name + ''',' from backupmediafamily b join backupset b1
on b1.media_set_id = b.media_set_id
where convert(varchar,b1.backup_start_date,101) = '03/29/2008' and type='D'
-- change 03/29/2008 to date when you performed backup
use output of above script in your restore statement after from. As you mentioned you are restoring database on different server that means you must have copied backup files there. So please change path accordingly. Remove last comma from result of above script.
It will make sure you are using correct backup set.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply