SQL Server Backup and Recovery

SQL Server Backup and Recovery News

February 02, 2016 02 Feb'16
An easier way to set up SQL Server on an Azure virtual machine

Microsoft offers a simpler way to configure SQL Server on an Azure virtual machine. Added automation should help speed up the connecting and provisioning process.
May 12, 2015 12 May'15
SQL Server 2016 preview announced for summer 2015

Microsoft CEO Satya Nadella announced the SQL Server 2016 preview for this summer. Its new features model the ethos of "mobile first, cloud first."

Bring yourself up to speed with our introductory content

database replication

Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information. Continue Reading
SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen. Continue Reading
Six sample databases for SQL Server and how to find them

SQL Server sample databases are useful for test and dev, but they can be difficult to parse. Use this SQL database sample overview to decide which to use and how to access them. Continue Reading

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

A quick tutorial on SQL Server maintenance plans

SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start. Continue Reading
Four free SQL Server tools every DBA can use

Various performance issues can arise in the day-to-day grind of managing databases. We've rounded up four free SQL Server tools that can help make DBAs lives a little bit easier. Continue Reading
SQL Server SSD technology becoming a solid storage choice

With recent improvements in solid-state drive technology, it's time to consider SSD devices for SQL Server storage uses. SSDs can address I/O performance problems, but wear is a worry. Continue Reading

Learn to apply best practices and optimize your operations.

SQL Server high availability best practices in the cloud

The cloud isn't immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud. Continue Reading
Five SQL Server maintenance steps you should take -- ASAP

Putting off SQL Server administration tasks can lead to problems. Do these often-neglected database maintenance items to help keep your systems running smoothly. Continue Reading
How to classify the complexity of a Microsoft SQL Server upgrade

Not all SQL Server upgrades are created equal and not all require the same level of effort. Learn when to go all out and when to conserve your energy by classifying your upgrades. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

How to resolve and avoid deadlocks in SQL Server databases

Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. 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
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