; Microsoft SQL Server 2016 : Attach a database by using SQL Server Management Studio | SQL Server

Big Entertainment On Demand

Best Streaming TV Online  - Visit Here

Microsoft SQL Server 2016 : Attach a database by using SQL Server Management Studio


Attach a database in SQL Server Management Studio 2016.  


























Before attaching the database

1 . Copy (two file e.g. the ‘database.MDF‘ file which contains the primary data, and the ‘database.LDF‘ file which logs) and 
2. Paste "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA" -according to your Microsoft SQL Server folder. 

Now we are ready to attach them.

3. Open SQL Server Management Studio....Click on connect button and then expand that instance.
4. Right-click Databases and click Attach. 



























5. Click ADD button ..

















6. Select your database for attach ...and click Ok button





















7. and click Ok button 


























Database is now attached to the SQL instance. ......




Share on Google Plus

About Sujay Sharma

Hi ! I am Sujay Sharma. I am working in Indian Railway as Guard. I am sharing my experience about Microsoft SQL Server with ASP.NET ,VB.NET,C#.NET,XML "" Thanks.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment