A service from Red Gate
Home SQL .NET Exchange Opinion Blogs Forums About
Sign in  | Join  | Help
SQL Home  >  Backup and Recovery
Allen White Automate your Database Integrity checks using SMO
by Allen White | 15 September 2007 |  4 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 |  7 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 |  13 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 |  76 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 |  16 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 |  14 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 |  1 comment |
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 (19 articles)
  SQL Training (3 articles)

  Database Administration (35 articles)
  SQL Server 2005 (21 articles)

  T-SQL Programming (45 articles)
  Performance (6 articles)

  Backup and Recovery (15 articles)
  SQL Tools (25 articles)

  SQL Home

  Learn SQL Server (19 articles)

  SQL Training (3 articles)

  Database Administration (35 articles)

  SQL Server 2005 (21 articles)

  T-SQL Programming (45 articles)

  Performance (6 articles)

  Backup and Recovery (15 articles)

  SQL Tools (25 articles)

Phil Factor
The Wrong Fabia
 There is often more than a twinge of embarrassment when an Email goes astray, and is received by the wrong person.... Read more...



 View the blog
Phil Factor The biggest secret?
 The first programmable computer was invented by Charles Babbage and Augusta Ada King, Countess of Lovelace....  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...

SQL Server Full Text Search Language Features
 SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... 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...

SQL Server 2005 Common Table Expressions
 Common Table Expressions (CTEs) are one of the most exciting features to be introduced with SQL Server... Read more...

Over 150,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-2008 Red Gate Software
Site map | Become an author | Contact us