Click here to monitor SSC
Grant Fritchey

SQL Server 2014 Backup Basics

There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014. Read more...

Allen White

Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets

There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen demonstrates. Read more...

Feodor Georgiev

Disaster Recovery in the Enterprise – Paying the Price to Avoid Extra Costs

Data Protection and Disaster Recovery (DR) are IT tasks that seldom get the same level of attention as development… until disaster strikes. Only if planning is adequate can an organisation be resilient in the face of unexpected problems. There are several steps that are needed to achieve an adequate DR process and the ability to restore business operations after a disaster. Read more...

Simple-Talk Editorial Team

Highway to Database Recovery

Discover the best backup and recovery articles on Simple-Talk, all in one place. Read more...

Warwick Rudd

Expanding AlwaysOn Availability Groups with Replication Subscribers

High Availability (HA) and Disaster Recovery (DR) can be provided for subscription databases from an AlwaysOn Avaliability Group, but the secondary replicas will need to be manually configured to create the new subscriptions Read more...

Gail Shaw

The SQL Server Instance That Will not Start

Everyone's SQL Server nightmare: The instance will not start. If such a problem strikes you, keep calm, follow Gail's advice, and you'll soon be back up and running. In the meantime, practice these steps so as to be ready! Read more...

Grant Fritchey

Backups, What Are They Good For?

Pixar recently confessed, in an engaging video, 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...

Shawn McGehee

Partial Backup and Restore

In this sample chapter from his book SQL Backup and Restore, Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup. Read more...

Grant Fritchey

How to Get Information About Your Backups

When you need to restore but aren't 100% sure about the contents of your backup files, what do you do? Head to the headers. Grant Fritchey explains how to find the useful bits in these huge stores of information and make sure you restore the right files. Read more...

Grant Fritchey

Centralized management: Tips for Managing Backups on Multiple Servers

Managing backups on a handful of servers should be a relatively straightforward process, but what about DBAs that need to automate to stay on top of large numbers of servers? What options are available, and how do they compare? Grant Fritchey looks at what's out there. Read more...

Grant Fritchey

Backup Verification: Tips for Database Backup Testing

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

Grant Fritchey

Faster Restores: Best Practices to Increase Speed

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

Grant Fritchey

SQL Virtual Restore and the Sandbox Development Environment

It is a problem to provide enough data for database development work, especially when it has to be managed, and has to comply with the conditions for using live data. Added to that are the constraints of disk space and the problem of providing risk-free deployment. Grant explains how three Red Gate tools and work together to provide a neat solution to providing the ideal sandbox development environment. Read more...

Laerte Junior

PowerShell Eventing and SQL Server Restores

When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time, serially. PowerShell is able to use events, so is ideal for, say, restoring fifty databases on different servers at once, and be notified when each is finished. Laerte shows you how, with a little help from his friends. Read more...

Grant Fritchey

Object Level Recovery with SQL Virtual Restore

Just occasionally, a user's mistake can make far more demands on a DBA than just a simple point-in-time restore. When things get complicated, and you have to work in a hurry, then that's when SQL Virtual Restore and SQL Data Compare can work together to save the day. Read more...

Rodney Landrum

Using SQL HyperBac to Compress Exported Data from SSIS and BCP

Because SQL Hyperbac works at the Windows I/O level, it can be configured to work not just with the database files, but also with the files for BCP, DTS, SSIS and SQL Trace/Profiler. This means that many ETL processes can be done faster, more securely and using less disk space than before. Read more...

Hugo Shebbeare

Plan de relève en cas de désastre pour les bases de données sur SQL Serveur

La haute disponibilité est une mesure du temps que cela prendra pour revenir à vos opérations régulières suite à un incident imprévu causant un désastre. Une planification stratégique et une documentation complète sont requises afin de surmonter ce défit. Si votre plan de relève échoue, cet incident pourrait devenir une catastrophe pour votre entreprise. Hugo Shebbeare discute de tous ces détails avec un exemple typique fournissant aussi tout le code et toute la documentation nécessaire pour éviter que cela arrive à vos opérations respectives. Read more...

Hugo Shebbeare

Disaster Recovery for SQL Server Databases

High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation. Read more...

James Moore

DBA:M and the SQL Backup 6.0 pre-release

Rodney Landrum, DBA manager in Pensacola, Florida, puts the pain of DBA:M into context as we learn about how SQL Backup can evolve to keep pace. Take a look at the changes we’ve got planned to help time-pressed DBAs in the forthcoming pre-release of version 6.0, including a new compression level and network resilience. Read more...

Dan McClain

How to Get Management Buy-In for Software purchases

There is a good chance that the process of purchasing software or hardware in your organization involves several people. DBAs will often initiate a request, but are not normally trained in the arts of influencing the management decision process to ensure that essentials get purchased. It is becoming essential to understand how to get Management support for software purchases. Dan offers nuggets of wisdom. Read more...

Allen White

Automate your Database Integrity checks using SMO

Allen White shows how to use Visual Basic to create simple routines that use SMO for inserting and deleting jobs from SQL Server Agent and for creating or deleting stored procedures in SQL Server. Read more...

Pop Rivett

Pop Rivett and the Expanding Log

Pop Rivett comes to the rescue when an expanding log file threatens the very existence of a young man's website... Read more...

Allen White

Alert-based Transaction Log Backups - Automate your database Maintenance Part 2

Part 2 of Allen White's "SQL Server Automation" series demonstrates how to use 'performance condition' alerts for more effective database log backups during periods of high database activity. Read more...

Allen White

Automate your Database Maintenance using SMO

The most important thing you can do as a database administrator is perform regular database maintenance. This includes regular backups, database integrity checks and optimizations. In Part 1 of a three article series, Allen White shows how to automate the backup of all of your databases, using SQL Server Management Objects (SMO) and either native backup or Red Gate's SQL Backup tool. Read more...

Pop Rivett

Pop Rivett and the Suspect Database

When a 'torn page' error corrupts a SQL Server database, threatening the survival of some vital data and a mainly harmless colleague, our curmudgeonly hero jumps into action… Read more...

Grant Fritchey

SQL Server 2005 Backups

If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes. Read more...

Pop Rivett

Pop Rivett's SQL Server FAQ No.4: Pop does Log Shipping

Pop Rivett demostrates the fine art of log shipping in SQL Server. Read more...

Pop Rivett

Pop Rivett's SQL Server FAQ No.3: Pop restores

Pop describes a stored procedure for restoring the most recent full backup of a SQL Server database and then applying all transaction logs. Handy to have around in case of emergency... Read more...

Pop Rivett

Pop Rivett's SQL Server FAQ No2: Pop Backs Up

Pop leaps into action to safeguard a young girls's data... Read more...

Robyn Page

Simple-Talk SQL Server Backup Crib Sheet

Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised. Read more...

Douglas Reilly

Minimizing the need to restore a backup

In the third part of this series, see how to configure your hardware to minimize the need to restore a backup. Read more...

Douglas Reilly

SQL Server backup

Strategies for keeping data available - second in a series exploring major facets of SQL Server backup. Read more...

Phil Basham

SQL backup protection

In the race to secure data, encryption is often overlooked. Philip Basham takes a look at the ramifications of data loss and how it can be prevented. Read more...

Simon Galbraith

SQL backup encryption

Read more...

Douglas Reilly

Why bother with backup

Backup is good for you, like eating a good diet and getting exercise. Unfortunately, folks are about as successful with backups as they are with diet and exercise. Read more...

Phil Factor
Searching for Strings in SQL Server Databases

Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google.... Read more...

 View the blog

Most Viewed

Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 If database design is done right, then the development, deployment and subsequent performance in... Read more...

SQL Server Index Basics
 Given the fundamental importance of indexes in databases, it always comes as a surprise how often the... Read more...

Reading and Writing Files in SQL Server using T-SQL
 SQL Server provides several "standard" techniques by which to read and write to files but, just... Read more...

Concatenating Row Values in Transact-SQL
 It is an interesting problem in Transact SQL, for which there are a number of solutions and... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.