Enumerates and backups all SSAS DB's  Read more...

Get backup status email daily to your inbox in HTML format.   Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

I have to support a third party application that periodically creates a new database on the fly. This obviously causes issues with our backup mechanisms. The databases have a particular pattern for naming, so I can identify the set of databases, however, I need to make sure I'm always backing up the newest one. Read this tip to ensure you are backing up your latest database in a series.  Read more...

Backup up all databases based on sys.databases.  Read more...

Backup up all transaction logs based on sys.databases.  Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.  Read more...

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...

Read more...

We've heard the confessional story from Pixar that Toy Story 2 was almost lost due to a bad backup, but sometimes there is no 'almost'. Grant Fritchey casts a sympathetic eye over some catastrophic data losses, and gives advice on how to avoid what he has termed an RGE (résumé generating event).  Read more...

Displays the last Full, Diff, and Log backup taken. If no backup has been taken that is displayed as well.  Read more...

Query to check estimated time of a task completion. Viz, alter index, backup, restore, etc.  Read more...

Read more...

A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

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...