microsoft.public.dotnet.framework

Cowboy

9/30/2008 6:42:00 PM

The backup statements can be done as DDL (Data Definition Language, a form
of SQL Script), so you can send the commands to the database via that
method. One option is to send as a SQL command, but that is not the best
option, as you lock up a thread while the command is running. You can also
set up the backup as a script using something like WSH and fire it off from
your app.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/Greg...

or just read it:
http://feeds.feedburner.com/Gre...

********************************************
| Think outside the box! |
********************************************
"bede" <diamond2165@hotmail.com> wrote in message
news:4c925bf9-1099-46e7-96b2-8f8a3d6013b0@l42g2000hsc.googlegroups.com...
> Hi All,
>
> I need to be able to backup a database held in SQLExpress 2005 but I
> must do it in code.
>
> I have managed this in SQL Server 2000 but can't for the life of me
> get anything to work on SQLExpress 2005.
>
> Has anyone managed this yet ?
>
> Thanks in Advance