Click to See Complete Forum and Search --> : database Restore problem


swaroopbhave
January 2nd, 2009, 01:44 AM
hi everyone,
coming to the point directly,
VB.Net WITH SQL SERVER 2000
PROBLEM:using SQLDMO reference,i am successdfull in taking database backup USING MY APPLICATION,
BUT,problem is when i try to restore that backup USING application that is connected to that database,i get error:cannot get exclusive access to the database as its already in use,
i agree if connection to the database is open.
but i have closed connection like con.close()
so what can be the problem??

i have tried connecting and disconnecting the server,please help me

i hope i am clear with it,if any confusion,please come up

dglienna
January 2nd, 2009, 07:27 PM
It means that something *else* is connected, so that you can't restore it.

swaroopbhave
January 3rd, 2009, 08:16 AM
no nothing else is connected,there isnt anything to be connected except my database connection string,whose connection is already closed

dglienna
January 3rd, 2009, 05:31 PM
Try setting it to NOTHING