How to restore back to local machine?

Thank you for your comment wisemx, but unfortunately, no joy.


I'm using SSMSExpress and tools/import is not available.


I right-click on the target database and choose restore from back-up and get an error as per the attached image.


Does anyone have any further suggestions?

 

Hi,

I have run the back-up on the server and downloaded the backup to my local machine. But I cannot restore the back-up from DiscountASP to my local machine.

The error says restore is looking for files on the E:/ drive - which presumably is the drive on the remote server.

Does anyone have any suggestions how I can easily restore the back-up to my local machine?

I am using SQL 2005 Express (and am a relative newbie) - so please be quite prescriptive if you can offer any advice.

Many thanks in advance

 

I'm not sure how it works with the express versions but...


To restore a DASP backup from the remote SQL 2005 machine:


1) Create the remote restore.
2) Use your local SQL Server management tools to copy, pump, the remote data to your local server.
(Tools Import/Export or DTS[local only] )

 

Make sure you are specifying the correct path for the backup file? Since the error seems to be related to an incorrect path.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

Mike/vvsharma,


many thanks for your advice - I can see where to specify the new .mdf and .ldf files.


I think there may be a problem with my .bak file from DASP - as it is described in SSMSE as ***INCOMPLETE*** and I get an error when trying to restore to a new database.

I have raised the query to DASP Technical team.


For reference, the two screen shots ae attached.
If you can offer any advice - that would be great; otherwise fingers crossed that DASP Technical guys can help.

Many thanks.

 

When you are setting the source and destination for the restore, you'll see General and Options on the left bar menu. Select options. It will show the original path as E:. Change it to your local path.

Mike

 

I was having all kinds of trouble a few days ago and was thinking the same as you, but I finally got it working. For some reason, I never could restorewhere my current websites are located. I had to put the .bak file in the sql server express path and also had to restore it to the same path.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\data

 

Mike,

thanks for your reply my query re restoring SQL Express to my local machine.
I've tried as you suggested (and also loaded SP2 as per DASP support), but still no joy.

The backupshows as ***INCOMPLETE*** when I select it, and the error message says "RESTORE error on pade (0:0)".

Would it be possible to offer me any further advice?

Many thanks for your help so far.

 

Bruce,


many thanks for your reply.


I have loaded the Publisher wizard, but canonly see how to publishfrom my local machine to your server; I need to go the other way.


Do you have any further information/advice on this related directly to DASP? - I'm relatively new to SQL and have spent a number of days so far to no avail.


Can you offer any simplifiedinstructions?


Many thanks in advance for your further support.

 

A bit of progress.....

I have managed to connect to DASP and created a script file on my local PC (is there another way?).
I have also opened SSManagement Studio Express to display the script and ran the query..

The output window shows various red errors - and I am not sure where to go next.

How do I get from this script file to having my local database updated or overwritten?

Any suggestions?

 

I think the best method would be with scheduled DTS.
You can create the local and remote servers and the data pumps.
The scheduling part is pretty straight forward.

Just get a hold of a Developer copy of SQL Server, ebay, programmersparadise, etc.
(Developer copies run less than $50.)