Restore a database
-
Does anyone know how to restore a .bak file to a MS SQL Sever. I think the .bak file is a backup of a .mdf file but I don't have the logs or any of the associated files.
All Tasks -> Restore Database... -> Restore from Device (radiobutton option) -> Select Devices... -> Add (supply a filename) After all this, you should be able to do all your "Oks" and restore as normal. Dallas
-
All Tasks -> Restore Database... -> Restore from Device (radiobutton option) -> Select Devices... -> Add (supply a filename) After all this, you should be able to do all your "Oks" and restore as normal. Dallas
-
I've tried that but I get some big long error about my data and log files not being found.
Choose the options tab and check "force restore over existing database". The3 backup filewas probably created on a different machine and the database and logfiles were located in a diufferent place (dreive/directory) on thet machine. The backuup 'remembers' the original locations, and tries to update the files in that place unless you select this option. Why would anyone waste time arguing with an accountant about anything? Their sole function is to record what happenned, and any higher aspirations are mere delusions of grandeur. On the ladder of productive contributions they are the little rubber pads at the bottom that keep the thing from sliding out from under you. - Roger Wright