Our vendor has provided us a copy of our data in a .bak files from SQL server. I want to run reports against this data. I have installed Express as well as Server management studio.
I presume I need to restore the .BAK file before I can run any reports? If so how does one do this?
Thanks in advance
In the UI right click on a database and select restore, or review the restore command in Books On Line;
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp
Also here is a short example;
RESTORE DATABASE MyNwind
FROM MyNwind_1
No comments:
Post a Comment