вторник, 30 апреля 2013 г.

MS SQL: How to attach db

USE [master]
GO
CREATE DATABASE [DBname] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\DBname.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\DBname.ldf' )
FOR ATTACH ;
GO