Hello everybody
I need to take backup of the database at the end of everyday from within an VB application.I need to have an interface(VB) to take a back up as the targeted user is not well versed with mssqlserver environment. How do i go abt doin' this.
Thankx in advance :pYou'll need to use SQLDMO, which you can include in your VB Project. Under 'Project->Reference' include Microsoft SQLDMO Object Library, if you are using a version of SQL Server prior to 7.0 the library will be Microsoft SQLOLE Object Library.
For examples:
Using SQL-DMO To Backup and Verify a Database (http://www.asp101.com/articles/carvin/sqldmobackup/default.asp)
15 Seconds : Code Samples : Backing Up A Database (http://www.15seconds.com/howto/pg000945.htm)
Introduction to DMO (http://www.swynk.com/friends/warren/dmointro.asp)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment