Hello,
I am trying to restore the bkp file, but get errors.
the steps are:
1. create database called: arachnode.net2. restore->database.3. Filling restore window with - To Database: arachnode.net - From database-> From Device: f:\arachnode.net.bakThe error is:
==================================
Restore failed for Server 'GUY\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------Program Location:
at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv) at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()
===================================
System.Data.SqlClient.SqlError: Directory lookup for the file "s:\AppDatabases\arachnode.net.mdf" failed with the operating system error 3(error not found). (Microsoft.SqlServer.Express.Smo)
------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQueryWithMessage(StringCollection queries, ServerMessageEventHandler dbccMessageHandler, Boolean errorsAsMessages) at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries) at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
What am I doing wrong?
You need to change the location of the database files in the options section. (Set them to a location that resolves on your local drive...)
For best service when you require assistance:
An open source .NET web crawler written in C# using SQL 2005/2008.
Twitter: http://twitter.com/arachnode_net
arachnode.net provides custom crawling and contracting resources. Please ask.
C# crawler, C# web crawler, C# site crawler
As a follow-up, in the restore as column of the graphic posted previously, change each of the s:\appdatabases... paths to a valid path on your computer/network. If you created a c:\appdatabases folder to store the db files, use that.