Skip to content

Instantly share code, notes, and snippets.

@apandrade

apandrade/CreateDatabaseFromFile.sql

Created March 14, 2024 00:17
Show Gist options
  • Save apandrade/d2a2f1641af0762bea7ed3557113992b to your computer and use it in GitHub Desktop.
Save apandrade/d2a2f1641af0762bea7ed3557113992b to your computer and use it in GitHub Desktop.
Download ZIP
Create Database from .mdf file
Raw
CreateDatabaseFromFile.sql
USE [master]
GO
CREATE DATABASE [database_name] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\<database name>.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\<database name>.ldf' )
FOR ATTACH ;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment