Click here to monitor SSC
A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
SQL Home  >  Backup and Recovery
Grant Fritchey Centralized management: Tips for Managing Backups on Multiple Servers
by Grant Fritchey | 13 December 2011 |
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
by Grant Fritchey | 06 December 2011 |  4 comments |
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
by Grant Fritchey | 02 December 2011 |  2 comments |
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
by Grant Fritchey | 15 July 2011 |
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.... Read more...
Laerte Junior PowerShell Eventing and SQL Server Restores
by Laerte Junior | 05 July 2011 |  3 comments |
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... Read more...
Grant Fritchey Object Level Recovery with SQL Virtual Restore
by Grant Fritchey | 15 June 2011 |
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
by Rodney Landrum | 01 June 2011 |  1 comment |
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... Read more...
Hugo Shebbeare Disaster Recovery for SQL Server Databases
by Hugo Shebbeare | 28 August 2009 |  4 comments |
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... Read more...
James Moore DBA:M and the SQL Backup 6.0 pre-release
by James Moore | 29 May 2009 |
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,... Read more...
Dan McClain How to Get Management Buy-In for Software purchases
by Dan McClain | 02 March 2009 |  5 comments |
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... Read more...
Allen White Automate your Database Integrity checks using SMO
by Allen White | 15 September 2007 |  5 comments |
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
by Pop Rivett | 22 June 2007 |  4 comments |
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
by Allen White | 20 April 2007 |  3 comments |
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
by Allen White | 05 April 2007 |  6 comments |
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... Read more...
Pop Rivett Pop Rivett and the Suspect Database
by Pop Rivett | 08 January 2007 |  14 comments |
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
by Grant Fritchey | 20 December 2006 |  94 comments |
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
by Pop Rivett | 30 October 2006 |  17 comments |
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
by Pop Rivett | 28 September 2006 |  7 comments |
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
by Pop Rivett | 22 September 2006 |  4 comments |
Pop leaps into action to safeguard a young girls's data... Read more...
Robyn Page Simple-Talk SQL Server Backup Crib Sheet
by Robyn Page | 10 August 2006 |  16 comments |
Robyn Page's crib sheet provides a terse but thorough roadmap of all of the important SQL Server backup-related considerations. Read more...
Douglas Reilly Minimizing the need to restore a backup
by Douglas Reilly | 15 September 2005 |  2 comments |
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
by Douglas Reilly | 08 August 2005 |  3 comments |
Strategies for keeping data available - second in a series exploring major facets of SQL Server backup. Read more...
Phil Basham SQL backup protection
by Phil Basham | 29 June 2005 |  1 comment |
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
by Simon Galbraith | 29 June 2005 |
Read more...
Douglas Reilly Why bother with backup
by Douglas Reilly | 25 April 2005 |  2 comments |
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...
  Learn SQL Server (80 articles)
  SQL Training (9 articles)

  Database Administration (115 articles)
  T-SQL Programming (130 articles)

  Performance (34 articles)
  Backup and Recovery (25 articles)

  SQL Tools (72 articles)
  SSIS (19 articles)

  Reporting Services (20 articles)

  SQL Home

  Learn SQL Server (80 articles)

  SQL Training (9 articles)

  Database Administration (115 articles)

  T-SQL Programming (130 articles)

  Performance (34 articles)

  Backup and Recovery (25 articles)

  SQL Tools (72 articles)

  SSIS (19 articles)

  Reporting Services (20 articles)

Phil Factor
Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL Server... Read more...



 View the blog
Phil Factor Using XML to pass lists as parameters in SQL Server
 (Updated 14th Jan 2012, and again 26th Jan 2012)Every so often, the question comes up on forums of how to pass a...  Read more...


 View the blog
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
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... 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...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

Creating CSV Files Using BCP and Stored Procedures
 Nigel Rivett demonstrates some core techniques for extracting SQL Server data into CSV files, focussing... Read more...

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

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2012 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us