Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Disaster Recovery (DR), Strategies Rss

<< Newer    Items 41 to 51 of 51   
 

Backup and Restore Back to Basics with SQL LiteSpeed

This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.   Read more...
By Greg Robidoux 2002/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,663 reads

Streamlining the Database Server Recovery Process

Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.   Read more...
By Gregory Larsen 2002/11/05 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 8,955 reads

VBScript Classes to Query SQL Server for Backup Information

A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.   Read more...
By Bruce Szabo 2002/08/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,118 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,934 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,500 reads

Review: Recover from Almost Anything with Log Explorer 3.0

Oops, a developer just forgot a WHERE clause when he ran his delete statement. Lumigent Log Explorer 3.0 can peer into the transaction log and find the culprit and roll it back. Read the review here of Lumigent's latest version.   Read more...
By Brian Knight 2002/07/23 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 3,974 reads

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000

In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster.   Read more...
By Brian Knight 2008/01/18 (first published: 2002/07/12) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 152,895 reads

In The Real World - Disaster!

A real world account of disaster recovery. (This article is being republished after the recent hurricane that hit the US East Coast).   Read more...
By Steve Jones 2012/12/12 (first published: 2002/04/22) | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 9,621 reads

Is 0% Downtime Possible?

Steve Jones examines the possible notion that a system can achieve 0% downtime. Read on to see if he thinks it's possible.   Read more...
By Steve Jones 2002/02/25 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 5,955 reads

Clustering SQL Server 2000 from 500 Feet

Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering.   Read more...
By Brian Knight 2004/11/25 (first published: 2001/07/02) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 68,104 reads

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.   Read more...
By Andy Warren 2006/06/16 (first published: 2001/05/07) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 24,530 reads
<< Newer    Items 41 to 51 of 51   
 
Tags
sql server 7 (16)    
administration (11)    
backup / restore (7)    
availability (3)    
miscellaneous (3)    
programming (3)    
replication (3)    
sql server 2005 (3)    
configuring (2)    
installation (2)    
product reviews (2)    
reviews (2)    
sql-dmo (2)    
dts (1)    
high availability (ha) (1)    
monitoring (1)    
security (1)