Thursday, 11 August 2016

How to attached user database MDF and LDF file in SQL Server

How to attached user database .MDF and .LDF file.


USE [master]

GO

CREATE DATABASE [Application_Registr] ON

( FILENAME = N'E:\Database\MSSQL$Sharepoint\Data\Application_Registr.mdf' ),

( FILENAME = N'L:\Database\MSSQL$Sharepoint\Log\Application_Registr_log.LDF' )

FOR ATTACH

GO



No comments:

Post a Comment