Tag Archives: backup

How to restore a database when you have a SQL Server backup file?

Oftentimes, when I get a database backup file, I usually perform a quick database restore without any hesitation. This usually works fine, but sometimes I get an annoying error message without any clue. Actually, SQL Server provides some commands that … Continue reading

Posted in Backup & Restore, Database Engine | Tagged , , , , | Leave a comment

FAQs: Database backup and restore for a mirrored database

Recently, I was asked several regarding database backup and restore for a mirrored database; therefore I think I need to write a blog post about them which may help others who has the similar doubts. Q: Can I do database … Continue reading

Posted in Backup, Database Mirroring, Restore | Tagged , , | Leave a comment

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