http://www.sqlservercentral.com/Content tagged Administering, Disaster Recovery posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/Learn how to use ALERTs, a SQL Agent job and a stored procedure (SP) to create a copy of your critical database backups on another physical machine as soon as the database backups are created.http://www.sqlservercentral.com/redirect/articles/2587/2006/09/08http://www.sqlservercentral.com/redirect/articles/2587/How many times have you run out of space in a database? What about on a file system? Andy Warren has had this happen a few times, especially when large imports take place. He brings us an article that describes some of the precautions he has taken to prevent this from happening. http://www.sqlservercentral.com/articles/Administering/runningoutofspace/1971/2005/07/14http://www.sqlservercentral.com/articles/Administering/runningoutofspace/1971/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. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/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. http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/2004/11/25http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do. http://www.sqlservercentral.com/articles/Administering/usingdifferenttechniquesforsqlserverautomation/1429/2004/08/02http://www.sqlservercentral.com/articles/Administering/usingdifferenttechniquesforsqlserverautomation/1429/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. http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/2004/07/05http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration. http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/2003/05/12http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically. http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/2003/01/14http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/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. http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/2002/12/23http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/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. http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/2004/07/05http://www.sqlservercentral.com/articles/Administering/fixingbrokenlogins/193/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. http://www.sqlservercentral.com/articles/Administering/disasterintherealworld2/747/2002/07/31http://www.sqlservercentral.com/articles/Administering/disasterintherealworld2/747/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. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/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. http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/2004/11/25http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/