?
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
Medium Priority
?
278 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Integration Management Part 2
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

839 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