Problem in restoring a database

Question

0.00/5 (No votes)

See more:

hi friends,

i'm using SQL 2005 server database. I hv developed an application in a vb.net 10. i am taking backup. and it is working ver fine. bt while restoring it is giving error.
My code is :

Dim query As String
Try
query = "Restore Database Employee From Disk='H:\Stuff\Backup\backup1.bak' "
Dim con As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=Trial1;Integrated Security=True;Pooling=False")
con.Open()
Dim cmd As SqlCommand = New SqlCommand(query, con)
cmd.ExecuteNonQuery()
MsgBox("Okk")
Catch ex As Exception
MsgBox(ex.ToString)
End Try

What is the mistake? please help me out.

Posted 6-Jul-13 3:38am

BCD23

Add a Solution

Comments

[no name] 6-Jul-13 9:40am

Could you tell what kind of error is it?

BCD23 6-Jul-13 9:42am

yaa... It is throwing exception as

RESTORE cannot process database 'Trial1' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.

[no name] 6-Jul-13 9:45am

Pretty obvious is it not? You have to have all of your users disconnected before your can restore a database.

BCD23 6-Jul-13 9:47am

bt for that, what shoukd i do? close a connection? throwing exception is at executeNonQuery()

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-07-06T03:51:00

Solution 1

The error message is pretty explicit: your database is in use. You have to close all connections to the DB while you do the restore. Not just your current app - but every application that is accessing the database has to be shut down, on all PCs.

Posted 6-Jul-13 3:51am

OriginalGriff

Comments

BCD23 6-Jul-13 9:56am

okk. bt der is no other connection except my application connection.

BCD23 6-Jul-13 9:57am

i'm not getting how to disconnect database before restore.

OriginalGriff 6-Jul-13 10:27am

Make sure that every time you create an SqlConnection, it is Closed and Disposed when you have finished with it - it is the recommended practice anyway with any object that implements IDisposable, as SqlConnection, SqlCommand, and so forth all do.
I'm betting that at some point you create a connection, and then just let it go out of scope - which doesn't close it until the Garbage Collector gets in, or your program exits.