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

Internet Television

Watch World wide Tv Channels , Movies , Sports - 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