Monday, March 26, 2012

Making backup from vb2005 program

Can i send a command from my vb2005 program to tell the database to make a backup? Or how is this else done...

You would 'ExecuteNonQuery', and the command.text (query) would be a 'fleshed' out version of the BACKUP DATABASE command.

For complete syntax, refer to Books Online, Topic: Backup Database

|||Another option would be to use the object model of SMO.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment