<div>
The problem is your version of SQL Server
</div>


The problem is your version of SQL Server

<div>
can i upgrade from standard to entreprise... &nbsp;&quot;fingers crossed&quot; &nbsp;lol
</div>


can i upgrade from standard to entreprise...  "fingers crossed"  lol

<div>
Run the setup program with SKUUPGRADE=1
</div>


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
BACKUP DATABASE TfsBuild TO DISK='C:\test\TfsBuild.bak<wbr />' MIRROR TO DISK='C:\test2\TfsBuild.ba<wbr />k'<br />
<br />
i've simplified the T statement as much as possible and it still errors out.... &nbsp;with the following error in the job history- <br />
<br />
Executing the query &quot;BACKUP DATABASE TfsBuild TO DISK='C:\\test\\TfsBuild.b<wbr />ak' MIRROR TO DISK='C:\\test2\\TfsBuild.<wbr />bak'&quot; failed with the following error: &quot;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.<br />
BACKUP DATABASE is terminating abnormally.&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly.<br />
<br />
Please help - I am not a DB Admin and i just want to get this wrapped up. <br />
THANKS<br />

</div>
</div>


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


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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.