Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.  Read more...

A Backup system is merely part of a recovery system. If your backups can't be used to recover the database, then they're useless. Do you regularly make sure that you can restore a database from your backups?  Read more...

We’d like your thoughts on what new features should go into our backup tools. Let us know by completing this short survey.  Read more...

How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.  Read more...

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.   Read more...

If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.  Read more...

Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.  Read more...

TSQL Script to backup selected databases. Use this to override the script generated by snapmanager for sql in a sql job which doesn't cater for new or deleted databases  Read more...

A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.   Read more...