Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

create database Expand / Collapse
Author
Message
Posted Sunday, September 16, 2012 9:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 17, 2012 8:16 PM
Points: 11, Visits: 27
How do you create a database from a data and log file?
Post #1359894
Posted Sunday, September 16, 2012 9:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:02 AM
Points: 1,869, Visits: 3,458
Use CREATE DATABASE FOR ATTACH (http://msdn.microsoft.com/en-us/library/ms176061(v=sql.100).aspx)
Post #1359895
Posted Monday, September 17, 2012 6:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:48 AM
Points: 28, Visits: 121
Hi,

Use attach db command or Open SSMS and right clich attach database>Select MDF file and clinic OK.
Post #1360150
Posted Monday, September 17, 2012 8:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 17, 2012 8:16 PM
Points: 11, Visits: 27
thank you
Post #1360530
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse