Search

Sunday, 2 September 2018

Restore Database without Log File (Just MDF File)

Everyone of us come across this one day or the other to restore database where we don't have a log file or the log file so here us the way we can restore such database without much effort


Script 

EXEC sp_attach_single_file_db @dbname='AdventureWorks',@physname='E:\Program Files\Microsoft SQL Server\DATA\AdventureWorksDW2012_Data.mdf'

Screenshot

No comments:

Post a Comment