Home > IT Answers > SQL Server > Unable to Restore Backup in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 Unable to Restore Backup in SQL Server 2005
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET
I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _ " move '" & lfile & "' to '" + Me.lblLogFile.Text + "'" Do you have any ideas?

Software/Hardware used:
ASKED: June 30, 2008  7:35 PM
UPDATED: September 20, 2008  11:07 PM
RELATED QUESTIONS
Answer Wiki:
It looks correct from here. Use SQL Profiler and see what it says as far as the actual command which is being run. What's the error message which is being returned?
Last Wiki Answer Submitted:  September 20, 2008  11:07 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _