Monthly Archives: May 2011

Taking tail-log backup what if the database is inaccessible

A tail-log backup is that a log backup that backs up the tail of the transaction log that have not yet backed up. In a event of database disaster, data loss cannot be prevented if tail-log backup cannot be taken. … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Where the database data and log files will be restored?

Generally, we could use Restore Database option in SSMS GUI or using RESTORE DATABASE T-SQL command when we want to restore a database from a database backup file (.bak). However, the destination database file (data and log) locations will vary … Continue reading

Posted in Uncategorized | Tagged , , , , | 2 Comments