SQL Server Backup and Recovery

SQL Server Backup and Recovery Get Started

Bring yourself up to speed with our introductory content

• SQL Server database recovery tool retrieves by the table

  Kroll Ontrack's new SQL Server database recovery tool was developed from customer feedback. It recovers selected tables instead of the whole database. Continue Reading

• AlwaysOn Availability Groups

  AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. 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

Evaluate SQL Server Backup and Recovery Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• SIOS SANLess cluster helps keep Epicure websites up and running

  Direct-sales food distributor Epicure deployed a new server cluster to keep its websites from being overwhelmed -- and saved money on SQL Server and storage in the process. Continue Reading

• SQL Azure automatic backup keeps it 'business as usual'

  Robert Sheldon explains the business continuity features added to SQL Azure, including automatic backup, self-service restore, manual copy, and export and geo-replication. These features are meant to keep the data available, even when the system ... 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

Product Reviews

• Remote access to the server is very useful but the RAID controllers lack a lot of functionality

  Powered by IT Central Station

  Valuable Features: Probably the Cisco Integrated Management Controller. • Improvements to My Organization: Remote access to the server is...Continue Reading

  Rating:

• Ahead of other vendors. Minor improvements are needed for registration of licenses and access to updated drivers.

  Powered by IT Central Station

  Valuable Features: iLO (Remote Management) is probably the best in the market, their RAID Cards (SmartArray) are also very good. •...Continue Reading

  Rating:

• I have found that the HP Proliant series servers have lived up to their moniker, in that they have always been reliable.

  Powered by IT Central Station

  Valuable Features: * High Performance * High Reliability * "Insight Management" of the hardware * Compatibility with all of the major...Continue Reading

  Rating:

Manage SQL Server Backup and Recovery

Learn to apply best practices and optimize your operations.

• How to provision a SQL Server virtual machine on Azure

  Basit Farooq provides two different methods for provisioning a SQL Server virtual machine on Windows Azure. He also explains the benefits of the Windows Azure virtual machine and how to migrate from on-premises to Windows Azure. Continue Reading

• 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

• 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