Recovery problem

In my production database i have lost data in three tables.so i just want to restore the data from my backup which was created.

I am connecting over remote desktop connetion to the server.

With in the databases i right click the database which has my three tables within them.

Then select all tasks->restore database

In restore i select files or file groups

then i select the day i want to restore the ok

It comes up with this error

Cannot open the back up device 'C:\programs\......'

device error or device online

Restore database is terminating abnormally

Is it because i am not doing at the server as i am connecting over remote desktop....

And my database has several tables apart from these three tables.is it possible for me just to restore these three tables.

i am using sql server 2000 database

Please let me know..

Are you using the GUI on the remote server or the GUI on your local machine? The GUI you use will need to be on the machine that the file resides if you are using localfile paths.

Also, you will only be able to restore those 3 tables using a PARTIAL restore if they exist in a separate filegroup to the rest of the data.If you only have one filegroup then you will have to restore the whole thing.

Either way, i think your only option is to do the restore to a separate database and then copy the data to your "live" db.

Check out the RESTORE information in Books Online as this gives a fairly thorough rundown of all the options.

HTH!

|||

Hi,

YOU CAN RETRIEVE THE BACKUP DATA FROM THE DELETED DATA..

I AM WORKING WITH SQL SERVER 2005.

JUST TRY ONCE AFTER THAT YOU CAN!!!!!!!!!!