Help with Restore .bak file of ms sql server 2000. 2

[qb828]

Hi!
I don't know a whole lot of ms sql server 2000.
I use it to create simple DBs but never had a chance to get in deep.

My coworker asked me if I can restore a backup file.
He said .bak file is the database(ms sql server database) back up.

I need someone to help me what I need to do to restore this file.

I tried the enterprise manager's restore method.
I don't really know how I have to use this.
I tried to restore from the device.
And i set the path where my file is(c:\mybackupdb.bak).
But when i try to run it, it gives me an error.
saying that my file is in e:\msql folder.
There is no e:\ drive in my computer.
I guesss when the backup was made, it used the device in the e: drive.

Can Anyone give me some suggestions??

This is what I know and did.

-Copy the backup file into C:c:\mybackup.bak
-open the enterprise manager
-open the restore method
-name the restore db as mybackup2
-restore from device
-select my file location.
c:\mybackup.bak
-run it
-throws me errors.
saying that there is no e:
Yes i don't have e: drive.

Please help
QB



QB

 

[JayKusch]

Lets see if we can get you straightened out here. OK ...

Open Enterprise Manager.

To make this easy ... if the new DB is not, Create a shell one by running. From the Databases level, right-click and choose "New Database". When it opens, give it the name of the DB you are trying to restore. Before going to "OK", go to the "Data Files" tab and look where the new DB physical location is. If it is rather long, jot it down or rely on your memory ... Do the same for the "ransaction Log" though the paths in mst cases are the same!

Click OK and create that shell DB.

Now Right click on the New Database and choose "All Tasks >> "Rstore Database".

Choose the DB name, and click on the "From Device" radio button. The choose "Select Device" and by default the "Disk" radio button is highlighted.

Click "Add" and and drill down to the backup file you have on your C: drive.

Should be able to click "OK" three times and wind up back to the "Restore Database" main screen.

Click "Options" ... You want to chose "Force restore of existing DB" and then make sure the "Move to physical file name" are set correctly to the path on your C: drive where you created that shell DB.

Once there ... click OK ... and you should be on your way!

Hope this helps ...


Thanks

J. Kusch

 

[qb828]

Oh my....J.Kusch!!!
You are wonderful. It worked. I was able to restore the backup file.

The reason I got error message was I didn't specify the correct "move to physical file name"..the file path.
That way why i got the error message like my bak file wasn't E:\ drive.

Anyway, Thank you very much for your awesome help.

Now I need to figure out what are in the database and get the data for the client.

Thank you.




QB

 

[port25]

Just off the top of my head...you could map a drive e:\ to a network share point. copy .bak file there and try the restore again. or if you have free space on your local disk create a logical e:\ drive and try the same thing.