Can I backup database using SQL server 2005 express to CD or DVD

Hi,

I tried to backup a database in MSSQL 2005 using Management studio express edition directly to CD. The CD is formated with Sonic DLA. I'am getting this error message:

TITLE: Microsoft SQL Server Management Studio Express

Backup failed for Server 'adilpc\sqlexpress'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Write on "D:\Test" failed: 87(The parameter is incorrect.) (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

Is it possible to backup directly to a CD or am I missing something? Any help is greatly appreciated.

Tnx

Adil

Hello

It's impossible to backup with SQL DServer 2005 Express directly to CD.

You can backup only to a file on a tape drive or a hard disk ( local or over a network connection ).

Afterwards, you have to copy this file to a CD

Sorry but SQL Server 2005 Express is free

It' possible with the standard,workgroup,Enterprise editions

Have a nice day