SQLServerCentral.com Articles tagged Backup

How to Identify and Backup the Latest SQL Server Database in a Series

Mon, 03 Dec 2012 07:00:00 UT

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.

Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent

Tue, 04 Sep 2012 09:36:18 UT

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.

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Tue, 14 Aug 2012 06:00:00 UT

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

Backups, What Are They Good For?

Fri, 25 May 2012 06:00:00 UT

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

SQL Server Backup and Restore

Mon, 26 Mar 2012 10:08:07 UT

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.

Faster Restores: Best Practices to Increase Speed

Wed, 14 Dec 2011 07:00:00 UT

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.

Backup Verification: Tips for Database Backup Testing

Mon, 12 Dec 2011 07:00:00 UT

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?

Survey: what features do you want from a backup tool?

Wed, 07 Dec 2011 07:00:00 UT

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

Using PowerShell for SQL Server Transaction Log Backups

Tue, 25 Oct 2011 06:00:00 UT

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.

Using PowerShell for SQL Server Database Backups

Fri, 30 Sep 2011 06:00:00 UT

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.

Simple Script to Backup All SQL Server Databases

Fri, 12 Aug 2011 06:00:00 UT

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.