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 |
|
Corobori
Posting Yak Master
105 Posts |
 Posted - 2004-03-09 : 08:31:45
|
| I am writing a vb.net application using MSDE. My user is asking me to provide him a backup and restore facility from inside the application. I had a look at this KB article http://support.microsoft.com/default.aspx?scid=kb;EN-US;241397 . It looks fine, I was just wondering if somebody put it into practice. What I see is that I'll have to pass down parameters such as the dbname and allow my user to specify the destination for the backup. Also I am wondering about the restore part of it. If it's necessary to detach the db, etc.jean-lucwww.corobori.com |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-09 : 08:46:04
|
| Better to create an admin database and stored procedures to do the backup and restore - this will be much easier to develop and test.You don't have to dtach the database before the restore - there is an option to replace the database files if the database exists. You will need to make sure there are no users connected to the database though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-03-09 : 09:27:11
|
| I don't understand what you mean by "to create an admin database"jean-lucwww.corobori.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-09 : 09:32:49
|
| You can create an Admin database to hold features that are database independent (like backups and restores). I usually put in something to save jobhistories as well.There is an SP here that will backup all databases on thye server.http://www.nigelrivett.net/BackupAllDatabases.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-03-09 : 09:40:25
|
| Ok, I see, it sounds better to me.jean-lucwww.corobori.com |
|
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-03-09 : 09:54:54
|
| While I was searching more ideas about this topic I came across samples using "SQLDMO.SQLServer". Is this also an option ?jean-lucwww.corobori.com |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-09 : 10:31:16
|
| Yep - enterprise manager is built using dmo so you can do anything it can (ish).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Corobori
Posting Yak Master
105 Posts |
Posted - 2004-03-10 : 21:10:50
|
quote:
Originally posted by nr
Yep - enterprise manager is built using dmo so you can do anything it can (ish).
Done that way, and it worked fine !jean-lucwww.corobori.com |
|
|
|
|
|
|
Backing Up MSDE