Using SQL Copy Data for Data Protection, Test Dev and Analytics (3 of 3)

This is part 3 in our multi-part series on Microsoft SQL server, backups, recoveries, copy data management. In parts number one and two we covered SQL backups and SQL restores, in detail and talked about a lot of considerations, different approaches, pros and cons, and performance impacts. If you haven't watched those I highly recommend you do as we're building on that based on that knowledge for this particular part of the series.

Continue Reading

Comparing Two SQL Server Restore Methods (2 of 3)

Here for Part Two in our series on SQL Server data protection, copy data management. Part one was all about SQL Server backup methods. Once you have the data, how do you use SQL copy data, what do you use it for?  Starting out with, people use it for recoveries, number one use case.  There's two methods of doing those recoveries, one is what we call traditional restore and the second is instant mount.  So let's compare and contrast the two, understand really what they do, and when you might want to use one versus the other.

Continue Reading
SQL backup

4 SQL Server Backup Methodologies and the Pros and Cons of Each (1 of 3)

This is part 1 of a multipart series on Microsoft SQL Server data.  We're talking about SQL backups and copy data, different methods of using SQL copy data and creating them. To start, let's review the different backup methodologies for SQL Server databases.  There are really four different approaches that people use:

Continue Reading