Sql server 2005 how to create a database from a dump of a database -


i have 2 files log.ldf , data.mdf thats suppose dump database . how can create new database old dump ?

in ssms open object explorer , connect server.
expand server clicking on plus [+] sign next server.
right-click on 'databases' folder , choose 'attach...'
click 'add' button , navigate files attach database files server.


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

html - Repeat image to extend header to fill screen -

javascript - Backbone.js getting target attribute -