Backups

Backup to the Cloud: The Silver Lining

  • Article

Offsite backups are vital to data integrity, allowing for preservation and backup of data in catastrophic circumstances. Cloud backups have been around for a while, but are now really coming into their own. Tony Davis looks at how to get set up with cloud backups for restores and disaster recovery.

2013-09-16

2,399 reads

Windows Server 2012 Deduplication – Should you use it with SQL Server Backups?

  • Article

Windows Server 2012 introduces native deduplication functionality. While this is a promising new Windows feature for other file types and characteristics, there are some potential pitfalls that you need to be aware of when it comes to deduplication specifically for SQL Server backup files.

4.92 (24)

2013-02-08

5,155 reads

Blogs

Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

By

An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...

Adding SQL Change Automation to Jenkins for Database CI

By

In a previous post, I explained how to get Jenkins running in a container...

DevOps for the DBA, Slide Deck

By

I have an all day seminar I give called “DevOps for the DBA”. If...

Read the latest Blogs

Forums

Multiple tables created in CDC

By DBA_007

Hello Team, I have enabled CDC for a particular database in SqlServer and enabled...

2 core machine with 4 Tempdb files

By AlphaTangoWhiskey

Just curious if there is a performance hit by having 4 tempdb files with...

User datareader access problem

By jay-h

I went to give a user (via AD account) datareader access to a number...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers