Backup SQLExpress 2005 in code

  • Thread starter Thread starter bede
  • Start date Start date
B

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
 
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! |
********************************************
 
Back
Top