Click here to Skip to main content
13,042,421 members (121,521 online)

Restore SQL Express database backup

saj_21 asked:

Open original thread
Dear friends,

I am developing a windows application in which i want to develop a restore utility in which i have a button and on click of that button i am creating a new database and restoring the given backup file.

my code is as follows

     private void Restore_Click(object sender, EventArgs e)
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLExpress;Integrated Security=True");
            DateTime nwDt = DateTime.Now;
            string strWinPath = Environment.GetEnvironmentVariable("windir");
            string strTemp = strWinPath.Substring(0, 1);
            StringBuilder sbOGDatabasePath = new StringBuilder(@"X:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\");
            sbOGDatabasePath.Replace('X', strTemp[0], 0, 1);

            string path = Environment.CurrentDirectory.ToString();
            string frmt = "DdMMMyyThTmm";
            string chngdt = nwDt.ToString(frmt);
            string sql = "CREATE DATABASE mydb2" + chngdt + "";
            string clientMDFPath = sbOGDatabasePath.ToString() + "mydb2" + chngdt + ".mdf";
            string clientLDFPath = sbOGDatabasePath.ToString() + "mydb2" + chngdt + ".ldf";
            SqlCommand cmd = new SqlCommand(sql, con);
                MessageBox.Show("Database created");
            catch (SqlException ex)
            SqlConnection Connection = new SqlConnection(@"Data Source=.\SQLExpress;Integrated Security=True");
            ServerConnection srvConn = new ServerConnection(Connection);
            Server srvSql = new Server(srvConn);

            if (srvSql != null)
                if (openBackupDialog.ShowDialog() == DialogResult.OK)
                    Restore rstDatabase = new Restore();
                    rstDatabase.Action = RestoreActionType.Database;
                    rstDatabase.Database = "mydb2" + chngdt + "";
                    string dbNm = "mydb2" + chngdt + "";
                    string dbLogNm = "mydb2" + chngdt + "_Log";
                    rstDatabase.RelocateFiles.Add(new RelocateFile(dbNm, clientMDFPath));
                    rstDatabase.RelocateFiles.Add(new RelocateFile(dbLogNm, clientLDFPath));
                    BackupDeviceItem bkpDevice = new BackupDeviceItem(openBackupDialog.FileName, DeviceType.File);
                    rstDatabase.ReplaceDatabase = true;
                    string sqlOn = "alter database mydb2" + chngdt + " set online with rollback immediate";
                    SqlCommand cmdOn = new SqlCommand(sqlOn, Connection);
                    catch (Exception esp)
                    MessageBox.Show("Database restored");
                MessageBox.Show("A connection to a SQL server was not established.", "Not Connected to Server", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

It gives me an error on following code:


Error : Restore failed for Server 'SHAILESH-LP\SQLExpress'.

InnerException : {"Directory lookup for the file \"C:\\Demo\\mysql\\mydb1_data.mdf\" failed with the operating system error 3(The system cannot find the path specified.).\r\nFile 'test_data' cannot be restored to 'C:\\Demo\\mysql\\mydb1_data.mdf'. Use WITH MOVE to identify a valid location for the file.\r\nDirectory lookup for the file \"C:\\Demo\\mysql\\mydb1_log.ldf\" failed with the operating system error 3(The system cannot find the path specified.).\r\nFile 'mydbb_log' cannot be restored to 'C:\\Demo\\mysql\\mydb1_log.ldf'. Use WITH MOVE to identify a valid location for the file.\r\nProblems were identified while planning for the RESTORE statement. Previous messages provide details.\r\nRESTORE DATABASE is terminating abnormally."}

Can anybody help me to solve this...

Thanks in advance.
Shailesh J.
Tags: C#, SQL, SQL-Server (SQL-Server-2008)


When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100