What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.  Read more...

This script provides very useful information about database backup and restoration.  Read more...

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.  Read more...

Read more...

This script helps with restoring backup files SQL Server 2005  Read more...

In a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 1, we have seen how we can come up with a disaster recovery procedure in SQL Server 2005. There are other ways to increase availability of your highly critical database in SQL Server 2005. What are those other options?  Read more...

I couldn't find a solid script for this so I put this together. It creates the database EXACTLY as it was with growth and proper file groups.  Read more...

Script to found out how much time before Restore or Backup Process remain  Read more...

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...

What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.  Read more...

When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.  Read more...

It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.  Read more...