SQL Server Backup and Recovery

SQL Server Backup and Recovery Get Started

Bring yourself up to speed with our introductory content

• Microsoft Azure Blob Storage database backup and restore

  With Microsoft Azure Blob Storage Service, you can easily perform database backup and restore. Here is a step-by-step approach to using the service. Continue Reading

• 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

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

• As our company quickly grows internally and through acquisitions, we replace old systems with these blades because they're easy to configure and are immediately usable upon installation.

  Powered by IT Central Station

  Valuable Features: HP’s blades are by far the most configurable of all the ones we’ve tried. We're a company that deploys less than 60 blades a...Continue Reading

  Rating:

• ​It's best for deployments in SMBs with low server requirements, but the hardware standards could be higher.

  Powered by IT Central Station

  Valuable Features: It's an affordable and scalable device that fits requirements for a SMB with a tight server budget. It's also easy to work...Continue Reading

  Rating:

• Redundancy, wherein one system can go down and the other is still fully functional, has given us the ability to withstand an outage we wouldn't have been able to before.

  Powered by IT Central Station

  Valuable Features: Ease of use in terms of setup No need for configuration High Availability Profile copying Auto-tiering One system can go down...Continue Reading

  Rating:

Manage SQL Server Backup and Recovery

Learn to apply best practices and optimize your operations.

• How to set up the new SQL Server data encryption feature

  If you're tired of decrypting data to perform operations on it, the new SQL Server data encryption feature Always Encrypted may be the answer. Continue Reading

• Two ways to encrypt database backups with SQL Server

  SQL Server 2014 provides two features that let database administrators easily encrypt database backups. An expert provides two demos that show you how. Continue Reading

• A look at StretchDB, a new feature in SQL Server 2016

  Stretch Database, a new feature in SQL Server 2016 often called StretchDB, lets companies "stretch" their databases to store infrequently used data in the cloud while keeping heavily used data on-premises. Continue Reading