Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-21 : 10:28:41
|
| Ramkumar Tangavel writes "Dear Sir,i want to write code in visual basic application, which has sql-server 2000 as backend database to backup and restore. plz, send a code spex to me to above mail id. Thanking you.with thanks,t.ramkumar." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-08-21 : 14:17:03
|
| I don't think anyone will send you the code, however we can point you in the right direction.The best way would likely be to use SQL DMO (Database Management Objects). Look them up in BOL, and/or MSDN.-Chad |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-21 : 15:38:32
|
| Merkin has a good intro article on SQL-DMO at [url]http://www.sqlteam.com/item.asp?ItemID=9093[/url].Another option would be to use the OSQL command-line utility to execute the SQL commands for Backup/Restore. |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-21 : 15:47:20
|
| You also have the option of writing your backup and restore code in stored procedures and then use ADO within VB to call these stored procedures.*************************Someone done told you wrong! |
|
|
|
|
|
|
Backup and Restore database