http://www.sqlservercentral.com/Content tagged Backup / Restore posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.http://www.sqlservercentral.com/articles/Administration/63641/2008/07/15http://www.sqlservercentral.com/articles/Administration/63641/This script will generate a restore statement with supporting MOVE operations to a new directory structure.http://www.sqlservercentral.com/scripts/TSQL/63271/2008/07/14http://www.sqlservercentral.com/scripts/TSQL/63271/Part 2 in this upgrade series lists the steps to point application traffic at a transition server while the primary cluster is rebuilt to Windows Server 2003 and SQL Server 2005.http://www.sqlservercentral.com/redirect/articles/63528/2008/07/10http://www.sqlservercentral.com/redirect/articles/63528/SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.http://www.sqlservercentral.com/articles/SMO/63126/2008/06/18http://www.sqlservercentral.com/articles/SMO/63126/Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/2008/04/15http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/61952/2008/03/17http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/61952/restore server/database users and roles from another server when we are restoring databases to another serverhttp://www.sqlservercentral.com/scripts/Backup+%2f+Restore/61375/2007/12/26http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/61375/Restore Many Backup FIleshttp://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31995/2007/11/08http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31995/Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.http://www.sqlservercentral.com/redirect/articles/61410/2007/11/01http://www.sqlservercentral.com/redirect/articles/61410/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31976/2007/10/31http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31976/http://www.sqlservercentral.com/scripts/Replication/31977/2007/10/30http://www.sqlservercentral.com/scripts/Replication/31977/http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/2007/10/19http://www.sqlservercentral.com/scripts/Lock+and+Connection+Management/31966/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31949/2007/10/02http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31949/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/32003/2007/09/14http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/32003/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/2007/09/14http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/http://www.sqlservercentral.com/scripts/Miscellaneous/31987/2007/08/21http://www.sqlservercentral.com/scripts/Miscellaneous/31987/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31843/2007/08/08http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31843/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31834/2007/07/30http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31834/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31799/2007/07/02http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31799/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31952/2007/06/27http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31952/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31742/2007/06/22http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31742/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31536/2007/06/11http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31536/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31569/2007/06/08http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31569/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31508/2007/06/07http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31508/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31532/2007/06/06http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31532/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31850/2007/05/28http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31850/http://www.sqlservercentral.com/scripts/Miscellaneous/31927/2007/05/24http://www.sqlservercentral.com/scripts/Miscellaneous/31927/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31926/2007/05/18http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31926/http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31928/2007/05/17http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31928/