Schema Only Database Backup

Use DBCC CLONEDATABASE to make a Schema Only Database Backup

Developing a backup plan

Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.

SQL Server Backup Types

One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.

Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware

Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in various ways depending on business objectives. As more organizations continue to move application and […]

Analyze and Improve SQL Server Backup Schedule

Daily Operations | Database Backup Schedule | Time Savings - In this tip we look at a script you can use to help you better schedule when SQL Server backups are run so there is not contention with backups running on multiple instances at the same time.

T-SQL query to get the latest available backup chain

T-SQL query to return the latest available database backup chain (Full, Differential and Log) of individual databases along with their backup size and compressed size.

Backup Techniques Available Exclusively When Using Azure VMs

Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.

5 reasons why backup and restore doesn’t cut it in dev and test

The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.

Google Announces 'Ice Cold Storage'

Google’s approach to ice cold storage eliminates the need for a separate retrieval process and provides immediate, low-latency access to content.

Backup to Recovery