March 7, 2006 at 6:50 am
Hi everybody,
I am trying to restore bunch of files given by my tean. When I am trying to do a restore with the following command
restore database ic2_test from networkdevice01, I get errored out. The error is:
Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'ic2_test' has 7 family members but only 1 are provided. All members must be provided.
I took sometime to really understand, what exactly the DBA had given me to restore. Now, I decided to use the command
restore database ic2_test from networkdevice01, networkdevice02, networkdevice03, networkdevice04, networkdevice05, networkdevice06 to overcome the earlier error.
Well, it bombed again..with an error
Server: Msg 3227, Level 16, State 1, Line 1
The volume on device 'networkdevice03' is a duplicate of stripe set member 2.
I did google around for sometime, but I haven't seen any documentation to get this fixed. Can somebody guide me to restore this type of backup files?
Thanks in advance!
Viking
March 7, 2006 at 7:22 am
Hello Viking,
I'm not sure of whether the below information is useful, as I haven't performed a restoration from tape.
{DISK | TAPE } =
'physical_backup_device_name' | @physical_backup_device_name_var
Allows backups to be restored from the named disk or tape device. The device types of disk and tape should be specified with the actual name (for example, complete path and file name) of the device: DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Mybackup.dat' or TAPE = '\\.\TAPE0'. If specified as a variable (@physical_backup_device_name_var), the device name can be specified either as a string constant (@physical_backup_device_name_var = 'physcial_backup_device_name') or as a variable of character string data type, except for the ntext or text data types.
If using either a network server with a UNC name or a redirected drive letter, specify a device type of disk. The account under which you are running SQL Server must have READ access to the remote computer or network server in order to perform a RESTORE operation.
n
Is a placeholder that indicates multiple backup devices and logical backup devices can be specified. The maximum number of backup devices or logical backup devices is 64.
This example restores a full database backup from a TAPE backup device.
RESTORE DATABASE MyNwind FROM TAPE = '\\.\tape0'Thanks and have a great day!!!
Lucky
March 7, 2006 at 8:06 am
As lucky mentioned, you have a striped backup. All of the files need to be specified in the restore.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 7, 2006 at 10:19 am
You need to use the WITH NORECOVERY option on each restore but the last. Basically, you restored one file and told SQL Server to stop here, when there were more files to be restored. On the last file being restored, use WITH RECOVERY.
-SQLBill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply