October 3, 2009 at 7:03 pm
I'm trying to utilize the mirrored backup option which I have been successful in backing up to two different servers, but, when I try to restore I get the following error:
the volumn on device " " is not part of a multiple family media set. bakup with format can be used to form a new mediaset.
any help would be greatly appreciated.
October 4, 2009 at 6:32 am
give us a tsql or any other more details information how do you perform this backup
October 4, 2009 at 9:52 am
It sounds like you did not use or create a mirror backup, but instead striped your backup across multiple files.
If you just put in two files in the backup window - you are setting up striped backups, not mirrored.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 4, 2009 at 12:36 pm
here is my backup syntax. As you can see I'm pointing to two different servers. By the way, this is a active/passive clustered environment. I'm tryiing to set this up so that whatever node is active this syntax will work.
Thanks for your help!
BACKUP DATABASE AdventureWorks TO DISK = '\\vrdbserver1\sql server backups\SCVR2000\adventureworks.bak'
MIRROR
TO DISK = '\\vrdbserver2\sql server backups\SCVR2000\adventureworks.bak'
WITH FORMAT,retaindays=14
October 4, 2009 at 1:35 pm
Okay, then you have specified multiple files for the restore where you only need to specify one of the backup files.
I am not sure what your intent is with a cluster. Why wouldn't you create a disk resource that is available to both nodes, cluster the disk resource and then reference that. You would then always have the drive available regardless of what node(s) are available.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply