October 1, 2008 at 11:08 am
Hello,
I have a SQL Server 2003 database. My question is that, I have a .BAK file, and can I use this to restore my database. Basically, I have some issues with the current database and would like to simply get the old one back. I am new to this, so please if you can help, make it in layman's term.
Any help will be appreciated. Thank You.
October 1, 2008 at 11:13 am
You should be able to right click on the database, select tasks, select restore > database. Select the "From Device" Radio button and then point to the appropriate file and you should start the restore. One more note, on the Options "tab" you need to check the "overwrite the existing database" option. (Please be sure this is what you want to do and make sure you have a backup of what you are overwriting as it will be gone and you won't be able to get back to it)
Be sure that you remove all open connections to the database prior to running the restore as that will block the restore from starting.
You can also use T-SQL. Refer to BOL for the proper examples of restoring from a .bak file on disk. Always my preference.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply