Today, I am going to show you a very interesting thing in SQL Server. How to restore database or create database without .LDF


Script for this :

--CREATE DATABASE EMPLOYEE ON (FILENAME='e:\EMPLOYEE.mdf') for attach_rebuild_log
Go

Try it.