Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mirrored backups Expand / Collapse
Author
Message
Posted Saturday, October 03, 2009 7:03 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:51 AM
Points: 125, Visits: 516
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.
Post #797471
Posted Sunday, October 04, 2009 6:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, October 03, 2010 3:50 AM
Points: 146, Visits: 178
give us a tsql or any other more details information how do you perform this backup
Post #797533
Posted Sunday, October 04, 2009 9:52 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #797560
Posted Sunday, October 04, 2009 12:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:51 AM
Points: 125, Visits: 516
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
Post #797578
Posted Sunday, October 04, 2009 1:35 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 4,379, Visits: 9,470
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #797586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse