First of all you check transaction log backup which contains the data and transaction log chain since the last full backup. If you have these then you can easily restore your database otherwise you will need to purchase a third party tool such as Lumigent’s Log Explorer to read the transaction log.
Pawan Mothsra
The OP said they had no backup, so they can’t check it. Check your drives for any .mdf, .ndf, .ldf files. If they are still there you can attach the database in Management Studio. If they’re not there, you’re out of luck. Hard way to learn about the importance of backups.
Discuss This Question: 1  Reply