Specify the destination location to restore sql Database from Backup Database by c#

Question

0.00/5 (No votes)

See more:

con.ConnectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=Database1;Integrated Security=True;User Instance=True";
         con.Open();
      cmd.CommandText = @"restore database Database1  from disk ='d:\\MyDatabaseBackup.bak'";

         cmd.Connection = con;
         cmd.ExecuteNonQuery();
         cmd.Parameters.Clear();
         con.Close();
         MessageBox.Show("Restore COMPLETE");

This code has no error. It Pop up Restore complete.

1)I want to extract mdf file from the backup file at specified location.(How can i specify the destination location in sql command )
2)above code runing properly means no error, but i don't know where the database is restored.

and i notice one thing here that, it's only successfull(means message box show Restore complete) to restore the database if the project from which backup my database is on it's same location

Posted 2-Oct-12 6:53am

footballpardeep

Updated 3-Oct-12 3:26am

v2

Add a Solution

Comments

footballpardeep 3-Oct-12 9:18am

Unable to open the physical file "c:\users\pardeep\documents\visual studio 2010\Projects\Bhoot\Bhoot\BhootDatabase.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
RESTORE DATABASE is terminating abnormally.

footballpardeep 3-Oct-12 9:19am

Now i am getting this exception

footballpardeep 3-Oct-12 9:21am

c:\users\pardeep\documents\visual studio 2010\Projects\Bhoot\Bhoot\BhootDatabase.mdf"

This was the path of my database when i make it's backup, if the project is on the same locatio then it say , successfull, but when i change the location of project, it gives my above error.

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)

Kiran Susarla · Answer 1 · 2012-10-03T01:31:00

Solution 1

You can use the T-SQL Restore statement like shown below

SQL

Restore DATABASE databaseName
FROM DISK='backup file path'
WITH NORECOVERY,
MOVE 'DataFile logical name' TO 'FileSystemPath',
MOVE 'LogFile logical name'  TO 'FileSystemPath'

Posted 3-Oct-12 1:31am

Kiran Susarla

Comments

footballpardeep 3-Oct-12 10:39am

con.ConnectionString = @"Data Source=.\SQLEXPRESS;Integrated Security=True;Initial Catalog=BRdatabase;User Instance=True";

con.Open();
cmd.CommandText = @"use [master];restore database BRdatabase from disk ='d:\\BRdatabaseBackup.bak' WITH NORECOVERY, MOVE 'BRdatabase' TO '" + Directory.GetCurrentDirectory().ToString() + "', MOVE 'BRdatabase_log' TO '" + Directory.GetCurrentDirectory().ToString() + "'";

cmd.Connection = con;
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
con.Close();
MessageBox.Show("rESORE COMPLETE");

footballpardeep 3-Oct-12 10:41am

above code give exception:
System.Data.SqlClient.SqlException (0x80131904): File 'F:\BRsetup' is claimed by 'BRdatabase_log'(2) and 'BRdatabase'(1). The WITH MOVE clause can be used to relocate one or more files.
RESTORE DATABASE is terminating abnormally.
Changed database context to 'master'.