July 9, 2001 at 10:19 am
can any one guide me how to take a back up and restore programatically through asp or vb.
i need both differential as well as full back through coding.
July 9, 2001 at 7:55 pm
I've got some sample code posted in an article http://www.sqlservercentral.com/columnists/awarren/dmointro.asp that you may find helpful, plus a couple other articles on DMO, including one about how to restore.
If you take a crack at it and get stuck, post what you have and we'll be glad to help!
Andy
July 10, 2001 at 11:09 am
I'd recommend against ASP due to the times involved. The best bet is to use VB or setup a stored procedure in SQL that perfroms the restore. Then use a table of some sort to implement a queue or use ASP to run sp_startjob that starts a SQLAgent task that runs your stored procedure.
You would have to then have the user notified using email or check back using an ASP page to see if the db has been restored.
Steve Jones
July 10, 2001 at 1:53 pm
I use asp to kick off a stored proc to do the restores just pass the variables from the asp page to the sproc and kick it off.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply