I want to be able to Backup a SQL Server 2005 Database from Visual Basic 2005. I'm looking for help here, as I have searched online and no luck.
ThanksEasy way - construct a SQL statement (see BACKUP DATABASE in books online for syntax) and submit that to the SQL Server for execution.
Still easy but I've never used - try using the SMO object model.
Easiest of all - have your server back itself up rather than rely on an external application.|||I want to be able to Backup a SQL Server 2005 Database from Visual Basic 2005. I'm looking for help here, as I have searched online and no luck.
Thanks
Ask your DBA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment