Problem solve

SQL Server Backup and Recovery

• Five steps for a successful backup of a stored procedure in SQL Server

  Follow these steps to use Management Studio for SQL 2005 for a successful SQL Server stored procedure backup.Continue Reading

• SQL Server backup best practices

  Backup compression and using differential backups are just two of the important SQL Server backup best practices described in this tip.Continue Reading

• Splitting SQL Server backups to multiple files

  Splitting database backups helps save space and run your SQL Server backups more efficiently. Get tips for executing this from Ashish Kumar Mehta.Continue Reading

• Fault tolerance and backups and snapshots, oh, yes

  They are vital tools all DBAs depend on. But what are the best products on the market these days? Expert Don Jones lets us know some of his favorites.Continue Reading

• No-risk SQL Server upgrade for SSRS no problem

  Worried about mishaps during your next SQL Server upgrade? What if you could perform an upgrade that is virtually risk free? It is possible, database architect Roman Rehak writes.Continue Reading

• In data warehousing, cost-benefit’s the issue with backup compression

  Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider.Continue Reading

• Three third-party tools for SQL Server you need to have

  SQL Server is packaged with an array of management tools, but it’s not complete. Several third-party tools for SQL Server can help with monitoring, backup and capacity management.Continue Reading

• Finding your way around SQL Server data preservation

  Need to know what a table looked like before changes were changes were made? There are several tools for SQL Server data preservation -- SQL Server change tracking and SQL Server database mirroring among them -- each with its own uses and ...Continue Reading

• Log shipping: Four tips to maintain RTO and RPO with SQL Server

  It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.Continue Reading

• Achieving high availability and disaster recovery with SharePoint databases

  Failover clustering and database mirroring are two useful SQL Server technologies that offer automatic failover within MOSS-related databases.Continue Reading

• How to 'do' SQL Server disaster recovery

  Understanding how backups really work in SQL Server can save you a lot of time and trouble. Learn where most SQL Server newbies get lost during the backup and recovery process.Continue Reading

• Choosing a SQL Server disaster recovery solution

  Determining your goals is the first step to selecting a disaster recovery technology. Here's how to weigh the pros and cons of the myriad options depending on your business requirements.Continue Reading

• SQL Server errors, failures and other problems fixed from the trenches

  SQL Server expert Matthew Schroeder gets down into the trenches to help resolve your SQL Server issues. Whether it's a failed cluster installation, a long-running stored procedure that causes a 3 a.m. phone call or a database in suspect mode, he's ...Continue Reading

• Get SQL Server log shipping functionality without Enterprise Edition

  Log shipping provides great high availability and disaster recovery, but only after paying the hefty licensing costs for SQL Server Enterprise Edition.Continue Reading

• SQL Server 2008 backup compression pros and cons

  Backup compression is a shiny new feature in SQL Server 2008, but what are the drawbacks? Here, SQL Server expert Roman Rehak examines some tradeoffs, such as increased CPU processing time.Continue Reading