0

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 ?

jjj
  • 125
  • 3
  • 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 01 '10 at 12:18
  • ya ya .. of course..! – jjj Jun 01 '10 at 12:25

1 Answers1

1

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.

Sean Howat
  • 1,849
  • 4
  • 20
  • 33
  • i tried that .. and it is not working , becouse the backup file on `j` server and dosen't appear on `k` server ..!! – jjj Jun 02 '10 at 04:58
  • and of course i am trying to restore it on `k` server ... – jjj Jun 02 '10 at 05: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 02 '10 at 14:08