Posts Tagged with SQL Clone

Using striped backups with SQL Clone

If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce... read more

Why people flocked to the SQL Clone live stream event

Live streaming events is something that’s rather new to Redgate, the first one being SQL in the City back in December, which was a great success. So with the launch of our new tool SQL Clone looming, we thought we’d do it again. There’s good reason too. While meeting people face-to-face at events is... read more

Why is my clone so small?

If you have a very large database, up to 64TB in size, SQL Clone will let you copy, or ‘clone’, that database many times, very quickly, making the full database available in multiple SQL Server instances across your development and test environments. And yet in each of these instances, the cloned database takes up... read more

Backup and restore of a SQL Clone

With SQL Clone, I can create multiple copies of my database, for testing, very quickly. First, I create an image of the source database, and then from that image I can create multiple clones. Each copy, or clone, appears to SQL Server as a normal database, and yet occupies a fraction of the disk... read more

SQL Clone competition – win an Amazon Echo Dot

Competition time! To celebrate the launch of SQL Clone, we’re giving away 25 Amazon Echo Dots and 5 SQL Clone licenses. We had a bit of fun creating a skill for Alexa that provisions databases using SQL Clone because, not only does SQL Clone provision databases in seconds using just megabytes of disk space,... read more

Database provisioning from backups using SQL Clone

In a previous article, Getting started with SQL Clone, I described how SQL Clone could remove much of the administrative burden from the database provisioning process, the advantages of a new, lightweight process to spin up “real databases” for use in development and test work, and finally how to produce data images and then... read more

SQL Clone: the aspirin for your database provisioning headaches

When developing a database as a team, most team members would generally prefer to work with their own, isolated copy of the database, rather than work on a shared development database. Up to now, however, there have been a number of additional management and security problems with the dedicated database approach and these burdens... read more