Win IT Maintenance and Troubleshooting:

Chapter 2: SQL Server

Maintenance and Troubleshooting

Display in sets of:

  • Replication techniques in SQL Server

    (presented by SearchSQLServer.com)

    Learning Center -  The following list will educate you on the replication process in SQL Server and also guide you on how to enhance your techniques when replicating your database(s). If you have database servers that must be involved in various types of replication, a...

  • Stored procedures: Who is running backups and restores and when

    (presented by SearchSQLServer.com)

    Tip -  Determining who issued SQL Server backup and restores and when they occurred is no simple task -- unless you have these stored procedures.

  • Checklist: How to archive SQL Server backups

    (presented by SearchSQLServer.com)

    Checklist -  Be able to recover quickly from an archived backup. Edgewood Solutions' Greg Robidoux explains why and how to archive and recover SQL Server database backups.

  • VB.NET timing out when backup changed to hourly

    (presented by SearchSQLServer.com)

    ITKnowledge Exchange Memb -  After changing transaction log backups from daily to hourly, one ITKnowledge Exchange member noticed that VB.NET was timing out. Find out what advice his peers have to offer.

  • Setting up and maintaining standby servers

    (presented by SearchSQLServer.com)

    Tip -  Standby servers may be used for continuous log shipping in the event of a database failure or to verify SQL Server backups. Here you'll find tips for setting up and maintaining a standby server.

  • Checklist: Maximize SQL Server backup performance

    (presented by SearchSQLServer.com)

    Tip -  Improve the I/O throughput of your SQL Server backups with the steps in this checklist by Edgewood Solutions' Greg Robidoux. It includes optimal backup configuration and scheduling options.

  • Don't use backup and restore to distribute database tools

    (presented by SearchSQLServer.com)

    Tip -  You may be tempted to use a full backup to distribute database-packaged tools to end users, but contributor Serdar Yegulap advises against it. Find out why in this tip.

  • Resolve errors received when restoring a database in SQL Server

    (presented by SearchSQLServer.com)

    Ask the Expert -  See how to restore a database after receiving a server error message by first running this command SQL Server as advised by our expert.

  • Check large backup sets before a full restore

    (presented by SearchSQLServer.com)

    Tip -  It's important to know whether or not you're working with a damaged backup set before trying to perform a restore. Contributor Serdar Yegulalp explains how to determine if a backup set is readable.

  • Managing backups for a large number of SQL Servers

    (presented by SearchSQLServer.com)

    Tip -  In a large SQL Server 2000 installation, you have to contend with many backup and recovery challenges, from monitoring to testing with minimal impact on network bandwidth. Edgewood Solutions' Greg Robidoux offers points to consider when establishing a...