Skip to content

Instantly share code, notes, and snippets.

@Reelix

Reelix/databaseFromFile.sql

Created November 23, 2016 22:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Reelix/f0bd5ef192ea419d0bd36278fc5b5bdd to your computer and use it in GitHub Desktop.
Save Reelix/f0bd5ef192ea419d0bd36278fc5b5bdd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
databaseFromFile.sql
USE [master]
GO
CREATE DATABASE [insert_database_name_here] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\fileNameHere.mdf' ),
FOR ATTACH ;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment