|
-
January 2nd, 2009, 02:44 AM
#1
 database Restore problem
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
-
January 2nd, 2009, 08:27 PM
#2
Re: database Restore problem
It means that something *else* is connected, so that you can't restore it.
-
January 3rd, 2009, 09:16 AM
#3
Re: database Restore problem
no nothing else is connected,there isnt anything to be connected except my database connection string,whose connection is already closed
-
January 3rd, 2009, 06:31 PM
#4
Re: database Restore problem
Try setting it to NOTHING
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!