http://www.sqlservercentral.com/Articles tagged Administering, SQL Server 7, 2000, Availability posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding. http://www.sqlservercentral.com/redirect/articles/2618/2006/10/18http://www.sqlservercentral.com/redirect/articles/2618/One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works. http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/2003/11/26http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/Standards are important in the computer business, both the hardware and software side. After looking at Coding Standards in a previous series, Steve Jones looks at the server side of standards beginning with hardware. http://www.sqlservercentral.com/articles/Administering/serverhardwarestandards/878/2003/01/30http://www.sqlservercentral.com/articles/Administering/serverhardwarestandards/878/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/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/This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0. http://www.sqlservercentral.com/redirect/articles/284/2001/07/02http://www.sqlservercentral.com/redirect/articles/284/