Backup SQLExpress 2005 in code

[bede]

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

 

[Cowboy \(Gregory A. Beamer\)]

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/GregoryBeamer#

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

********************************************
| Think outside the box! |
********************************************