http://www.sqlservercentral.com/Articles tagged Backup and Recovery posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.http://www.sqlservercentral.com/articles/Analysis+Services/63382/2008/07/17http://www.sqlservercentral.com/articles/Analysis+Services/63382/Use the DTUTIL Command Prompt Utility to Copy / Install / Delete the SSIS Package deployed in MSDB Database to file systemhttp://www.sqlservercentral.com/articles/SSIS+Package+Deployment/63263/2008/07/09http://www.sqlservercentral.com/articles/SSIS+Package+Deployment/63263/One of the first things that should be done when managing SQL Server is to setup an appropriate backup plan in order to minimize any data loss in the event of a failure. Along with setting up a backup plan there are certain database configurations that need to be setup to ensure you are able to backup databases correctly. In this tip we will look at the different recovery models that SQL Server offers and how to choose a recovery model for your database.http://www.sqlservercentral.com/redirect/articles/63138/2008/05/30http://www.sqlservercentral.com/redirect/articles/63138/SQL Server trainer and longtime expert, Andy Warren brings us a great article on one basic skill that every DBA should know.http://www.sqlservercentral.com/articles/Administration/62930/2008/05/12http://www.sqlservercentral.com/articles/Administration/62930/ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or nothttp://www.sqlservercentral.com/redirect/articles/62929/2008/05/12http://www.sqlservercentral.com/redirect/articles/62929/SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008http://www.sqlservercentral.com/articles/Compression/62746/2008/05/05http://www.sqlservercentral.com/articles/Compression/62746/On my database server I have my databases set to the full recovery model, but the transaction logs get quite big, so I am issuing a BACKUP LOG with NO_LOG. I am not exactly sure if this causes any issues, but I know that I am able to free up space in my transaction log and shrink the file. Is this the correct way to handle this situation?http://www.sqlservercentral.com/redirect/articles/62708/2008/04/10http://www.sqlservercentral.com/redirect/articles/62708/Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.http://www.sqlservercentral.com/articles/Editorial/61871/2008/01/09http://www.sqlservercentral.com/articles/Editorial/61871/Describes how data changes for differential backups are recorded using dbcc pagehttp://www.sqlservercentral.com/articles/Administration/61591/2007/12/11http://www.sqlservercentral.com/articles/Administration/61591/Backups are the foundation of any well run database server, or even any computer system. Numerous articles have been written about SQL Server backups and new author Paulo Luis brings us a new twist on building automated backups using devices. http://www.sqlservercentral.com/articles/Backup+and+Recovery/2574/2006/08/29http://www.sqlservercentral.com/articles/Backup+and+Recovery/2574/You have many SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.http://www.sqlservercentral.com/redirect/articles/2369/2006/04/13http://www.sqlservercentral.com/redirect/articles/2369/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/One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment. http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/2005/06/14http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup. http://www.sqlservercentral.com/articles/Backup+and+Recovery/implementingaflexiblebackupstrategy/1535/2004/10/19http://www.sqlservercentral.com/articles/Backup+and+Recovery/implementingaflexiblebackupstrategy/1535/SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan. http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/2004/06/29http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/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/New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think. http://www.sqlservercentral.com/articles/Rants/fromthesoapboxdoesanyoneknowwhatdisasterrecoveryis/1266/2004/01/28http://www.sqlservercentral.com/articles/Rants/fromthesoapboxdoesanyoneknowwhatdisasterrecoveryis/1266/The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans. http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups2/785/2003/08/28http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups2/785/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/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. http://www.sqlservercentral.com/articles/Disaster+Recovery/streamliningtherecoveryprocess/837/2002/11/05http://www.sqlservercentral.com/articles/Disaster+Recovery/streamliningtherecoveryprocess/837/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/Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code! http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/2002/10/15http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/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/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. http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/2002/08/22http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/