I am using Visual Basic Express 2010 to create a project. My database is SQLExpress. My project requires to read certain values from database while opening.
To backup database, I simply copied database from the location to other, it worked successfully. But while replacing the database as restore, as database is already opened while running project, it is unsuccessful.
In this case. how can I restore my database? Is there any other way of doing same except copy and paste? Please help me with code.
Thank you in advance
To backup database, I simply copied database from the location to other, it worked successfully. But while replacing the database as restore, as database is already opened while running project, it is unsuccessful.
In this case. how can I restore my database? Is there any other way of doing same except copy and paste? Please help me with code.
Thank you in advance