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

Can an SQL Server stored procedure write output to an excel formated file?

Hi,
To clarify the previous post.
I would like to write a stored procedure that a client can call. The
stored procedure will then output its result in an excel file.
Thanks,
chariaYou have things a little reversed. You should have the stored procedure
return the data. How you call the report will determine how it is rendered
(HTML, CSV, PDF, Excel etc). When integrating reports you can use URL
integration or webservices. Neither of which would be that easy from a
stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<cpeters5@.gmail.com> wrote in message
news:1120582350.023702.281780@.g43g2000cwa.googlegroups.com...
> Hi,
> To clarify the previous post.
> I would like to write a stored procedure that a client can call. The
> stored procedure will then output its result in an excel file.
> Thanks,
> charia
>