Unable to Restore Backup in SQL Server 2005
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

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.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _