I guess snapshot in SQL Server is more like undo data in oracle which can be used to revert a table to a point in time (flashback). I will try...

Thanks,

So it means that we can only mirror the backup copies of the Transaction Logs, but not the LDF files themselves. So in case MDF and LDF is missing (assuming...

One more thing I want to ask about - in Oracle we can safeguard the safety of archive log files by specifying more than one location for archive logs. In...

Thanks Guys, I finally got the solution 🙂 I'm adding it in case anyone else is looking to do the same.

1. I took a Full Database Backup.

2. I created a...

Suppose the MDF Files are missing and LDF are available. Full Database Backup and Transactional Log Backup are also available.

When I restore the Database using 'RESTORE DATABASE CMS_TEST FROM DISK...

Thanks to all of you for your input.

Based on the replies, I guess the following scenario is correct.

1. Database Full Backup occurred at 12:00 AM

2. Transactional log backups are scheduled...

Hi John

When I took the Database backup I also took the backup of Transaction Log. In case the MDF files are missing, how can we restore using a full backup...

Thanks.

When I tried 'restore database CMS_TEST from disk ='D:\Backups\try' with norecovery' it gives the following message.

Msg 3159, Level 16, State 1, Line 1

The tail of the log for the database...

Thanks for the reply.

Please guide on how to apply transaction log on Full Backup Restore. My main concern is that if, for example, a full backup was performed last night....

Great Article, but what if primary constraint has several foreign key constraints from other tables referencing to it? Sometimes the foreign key constraints can be in 100s. Do we have...