Wednesday, August 1, 2018

RESTORE MSSQL DATABASE WITHOUT LDF ONLY MDF

RESTORE MSSQL DATABASE WITHOUT LDF ONLY MDF


USE master
GO
CREATE DATABASE <database_name>
ON (FILENAME='C:\<database_mdfname>.mdf')
FOR ATTACH_FORCE_REBUILD_LOG