Solved

help... i am trying to use the mirror to command to copy my db backup to a second location

Posted on 2008-10-15
4
259 Views
Last Modified: 2012-05-05
I have MS SQL Server 2005 with sp 2 installed - yet when i try to create a simple backup maintenance plan it errors out when i add the mirror to command.

BACKUP DATABASE TfsBuild TO DISK='C:\test\TfsBuild.bak' MIRROR TO DISK='C:\test2\TfsBuild.bak'

i've simplified the T statement as much as possible and it still errors out....  with the following error in the job history-

Executing the query "BACKUP DATABASE TfsBuild TO DISK='C:\\test\\TfsBuild.bak' MIRROR TO DISK='C:\\test2\\TfsBuild.bak'" failed with the following error: "Backup mirroring is not available in this edition of SQL Server. See Books Online for more details on feature support in different SQL Server editions.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Please help - I am not a DB Admin and i just want to get this wrapped up.
THANKS
0
Comment
Question by:POHS
  • 3
4 Comments
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22725170
The problem is your version of SQL Server
0
 
LVL 15

Accepted Solution

by:
jorge_toriz earned 500 total points
ID: 22725195
Mirrored backup sets are only supported by the Enterprise Edition (developer edition too)
0
 

Author Comment

by:POHS
ID: 22725974
can i upgrade from standard to entreprise...  "fingers crossed"  lol
0
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22726469
Run the setup program with SKUUPGRADE=1
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now