http://www.sqlservercentral.com/Articles tagged Administering, SQL Server 7, 2000, Backup and Recovery posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP. http://www.sqlservercentral.com/articles/Administering/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administering/pushftp/473/Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does. http://www.sqlservercentral.com/articles/Administering/reviewoflumigentlogexplorerv4/1282/2004/02/13http://www.sqlservercentral.com/articles/Administering/reviewoflumigentlogexplorerv4/1282/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/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This article by new contributing member Bob Musser shows you how to reduce the amount of scans that SQL Server Agent does against databases. Not for the faint of heart. http://www.sqlservercentral.com/articles/Administering/squeezingwastedfullscansoutofsqlserveragent/914/2003/02/13http://www.sqlservercentral.com/articles/Administering/squeezingwastedfullscansoutofsqlserveragent/914/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/Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book! http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/2002/11/19http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server. http://www.sqlservercentral.com/articles/Administering/orphan_user/853/2002/11/18http://www.sqlservercentral.com/articles/Administering/orphan_user/853/All of do us regular backups. Ok, all of us SHOULD do regular backups. In this article Andy comments on why having a backup plan isn't enough and why you should look at some other options for when you need to fix data errors. This really speaks to the goal of minimizing down time using low tech, readily available solutions. If you're not interested yet, we'll add this - one of the alternatives he suggests is Microsoft Access! http://www.sqlservercentral.com/articles/Administering/alternativestosqlbackups/828/2002/10/28http://www.sqlservercentral.com/articles/Administering/alternativestosqlbackups/828/Steve found a gaping hole in his backup process. One that he plugged with this script to move log files around the network in the event of a server failure. If you can't afford to lose a day of work, read about his solution. http://www.sqlservercentral.com/articles/Administering/pushthoselogsaway/812/2002/09/30http://www.sqlservercentral.com/articles/Administering/pushthoselogsaway/812/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/Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean! http://www.sqlservercentral.com/articles/Administering/maintenanceplansbackupsandremovingoldfiles/702/2002/06/10http://www.sqlservercentral.com/articles/Administering/maintenanceplansbackupsandremovingoldfiles/702/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles! http://www.sqlservercentral.com/articles/Administering/maintenanceplansbehindthescenes/693/2002/05/27http://www.sqlservercentral.com/articles/Administering/maintenanceplansbehindthescenes/693/In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all! http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplansunderthecovers/686/2002/05/21http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplansunderthecovers/686/DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP. http://www.sqlservercentral.com/articles/Administering/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administering/pushftp/473/