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

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
POHSAsked:
Who is Participating?
 
jorge_torizConnect With a Mentor Research & Development ManagerCommented:
Mirrored backup sets are only supported by the Enterprise Edition (developer edition too)
0
 
jorge_torizResearch & Development ManagerCommented:
The problem is your version of SQL Server
0
 
POHSAuthor Commented:
can i upgrade from standard to entreprise...  "fingers crossed"  lol
0
 
jorge_torizResearch & Development ManagerCommented:
Run the setup program with SKUUPGRADE=1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.