Need help in solving the error

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi all

While restoring the database i am getting the below error

SQL

The file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\project_blank_blank.mdf' cannot be overwritten.  It is being used by database 'project_blank_blank'.
File 'project_blank_blank' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\project_blank_blank.mdf'. Use WITH MOVE to identify a valid location for the file.
The file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\project_blank_blank_log.LDF' cannot be overwritten.  It is being used by database 'project_blank_blank'.
File 'project_blank_blank_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\project_blank_blank_log.LDF'. Use WITH MOVE to identify a valid location for the file.
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.

this is my restore query

SQL

Dim str As New SqlCommand("use master; RESTORE DATABASE " & txtCompanyCode.Text & " FROM disk='" & dest & "'", con)

Please help me out..

Posted 19-May-13 20:46pm

Code-Hunt

Add a Solution

2 solutions

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)

Abhinav S · Answer 1 · 2013-05-19T20:49:00

Solution 1

You cannot restore a database till there are connections pending with the old one.
If you are the administrator, you can close these open connections through Management Studio or through code.

Posted 19-May-13 20:49pm

Abhinav S

Comments

[no name] 20-May-13 2:53am

Then is there any other solution..because i have to attach like this..

Mohammed Hameed · Answer 2 · 2013-05-19T21:00:00

There could be no other solution except as proposed in Solution 1.

And it make sense, how can the SQL Server perform a Restore operation while the database is being used in some application or service?

If let's suppose that if it allows like this then obviously chances are there that your restored database might be get corrupted or will not function properly.