SQL Clone

Unwrapping, Unboxing and Installing SQL Clone

  • Article

If you are evaluating a tool such as a text editor or spreadsheet, it is easy: you just install it, you run it, you decide whether you need it. Job done. However, a similar 'unboxing' or 'unwrapping' of SQL Clone, and installing across a network, is not so quick and easy. Phil Factor's solution is to install and run a complete installation of SQL Clone on a single box. This allows you to try everything out, creating images and deploying clones, while isolated from the network. It can then be extended across a network, subsequently, when it's been fully tested.

2019-11-14

Self-service and Delegation with SQL Clone 4 Teams

  • Article

SQL Clone 4 introduces a new access control feature called Teams, allowing granular control over the SQL Server instances, images and clones to which each group of users has access. Here James Murtagh explains how Teams makes it easier to manage the safe distribution of database copies throughout the organization, to the various teams that need them for development, testing, training or analysis.

2019-09-11

SQL Clone for Unit Testing Databases

  • Article

Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.

2019-06-04

Using striped backups with SQL Clone

  • Article

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 a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works.

2017-05-29

2,237 reads

Blogs

Daily Coping 8 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Don’t be afraid of No

By

How many times have you been afraid to hear “No”? We have all been...

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Read the latest Blogs

Forums

How to do a Matrix properly

By julia.streatfield

Hi everyone I have some events data with related delegates.  The events have two...

DBCC CHECKDB output

By stevec883

I ran a DBCC on a database and it found some anomalies. Just looking...

Why is sys.master_files showing the size of RBS files as 0?

By hurricaneDBA

Dear Everyone I hope you are all safe in these strange times. I am...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers