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
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