[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
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
?
276 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

650 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