restore database

[3615]

I need to Backup and restore a database from a VB application.

First to backup a database using BACKUP DATABASE etc... in a stored procedure called from VB, there is no problem.

But when I use a command RESTORE DATABASE FROM etc...
Error Message: "System admin exclusivity needeed..." or something Like this(Sorry for my english...)

How can i do ?

thanks

 

[dbmsguy]

I would suspect that there are users connected to the database when you are trying to restore.... try putting a sp_who in before the restore to see. if there are people in the db, then you will have to either kill them or have them change the database context.

I have a stored proc that will kill all users if that is the problem. Paul

http://www.dbmsguy.com

 

[3615]

Thanks for your answer Paul.

For my tests i'm the only user of the database.

I tried to execute a "RESTORE DATABASE etc..." with a new connection on a MASTER database (from my VB program) to be sure that there is no connection on MY database, and that is OK.

But i can't do that if my VB program have been connected 2 times. I set all active ADODB.connections to nothing before to restore MY database, but it seems that one connection is still active and i can't find it.

This is a VB Problem now ?

 

[tlbroadbent]

Are you logging in to the database you want to restore? Issue a "USE master" command prior to the restore command so the context of your connection is master rather than the database being restored. Terry

http://www.defendscouting.com/

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes