Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i have two deferent Servers databases connections , let say j and k .. and i have

backup data file in j, i named it jtok.bak ..

now , i am trying to restore a database in k from jtok.bak , the database name is kkk ...

so ... is there a way to do that ?

share|improve this question
So you're trying to restore a database backup named jtok.bak from server j to a datbase on server k named kkk? Yes, there is a way to do that. Would you like specifics on how to do it? – joeqwerty Jun 1 '10 at 12:18
ya ya .. of course..! – jjj Jun 1 '10 at 12:25
up vote 1 down vote accepted

Right click your 'kkk' database and go to Tasks -> Restore -> Database. Choose the From Device option and browse to your backup file. Click on the Options page and select Overwrite the existing database. Below that checkbox is an area where you can make sure the data and log files are in the right spot. Once everything is set up how you want it just click OK and it should restore.

share|improve this answer
i tried that .. and it is not working , becouse the backup file on j server and dosen't appear on k server ..!! – jjj Jun 2 '10 at 4:58
and of course i am trying to restore it on k server ... – jjj Jun 2 '10 at 5:02
Well you'll need to put the backup file on the k server. You could do this through some sort of shared folder, usb, etc... – Sean Howat Jun 2 '10 at 14:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.