RESTORE Probs

[NevG]

Hi Gang

I'm still having trouble restoreing a SQL server dbase through VB when I am using it.

I have several data environments in place allwith connection strings obviously. I have tried changing these strings, aND also using the USE MASTER GO approach before restoring but I continually get

'Database in use' Errors

Please help guru people

 

[tlbroadbent]

Is it the VB program connection that prevents the restore or are other users connected and using the database?

If other users are in the database, you'll want to get them out and set the database to single user mode. That can be problematic if users are continually connecting. You can download a stored procedure from SWYNK.COM to kill user connections and set the database in single user mode.

Download from

http://www.swynk.com/sqlhome/user7.asp.

Terry

http://members.home.net/tlbroadbent/index.htm