mirrored backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » mirrored backups

mirrored backups

Rate Topic

Display Mode

Topic Options

Author

Message

ericwenger1

Posted Saturday, October 03, 2009 7:03 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:59 AM
Points: 118, Visits: 465

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

Marcin Gol

Posted Sunday, October 04, 2009 6:32 AM

SSC-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

Jeffrey Williams 3188

Posted Sunday, October 04, 2009 9:52 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:21 AM
Points: 4,317, Visits: 9,216

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

ericwenger1

Posted Sunday, October 04, 2009 12:36 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:59 AM
Points: 118, Visits: 465

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

Jeffrey Williams 3188

Posted Sunday, October 04, 2009 1:35 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:21 AM
Points: 4,317, Visits: 9,216

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 »

Permissions