May 30, 2009 at 3:42 pm
I have a .BAK file on my desktop. I created a new database. I need to restore it from the .BAK file on my desktop. When I right click the new database in SQL Server Enterprise Manager and seelct properties where do I get the path to correct the Data File and Transaction Log location? :crazy:
May 30, 2009 at 8:31 pm
newbie101 (5/30/2009)
I have a .BAK file on my desktop. I created a new database. I need to restore it from the .BAK file on my desktop. When I right click the new database in SQL Server Enterprise Manager and seelct properties where do I get the path to correct the Data File and Transaction Log location? :crazy:
You dont really need to create a database. In SSMS, right click on databases -> tasks -> restore
You'll get a window. Click on restore from device. Click on ADD, select your backup file here and check it. You'll get properties to locate your data and log file.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply