• Adam Thurgar

Production data in non prod


I am not going to lecture anybody about having PI or sensitive data from production on any of your non prod servers.

Over the years I have seen many methods for getting data from prod to non prod.

I have seen transactional replication setup pulling data from production publisher

I have seen log shipping setup. A sneakier method was to go and copy transaction logs from the destination server and re-applying them.

Copying of database backups from the database server using Robocopy jobs.

Or using Robocopy jobs to pull the backups from the SAN.

An SSIS package to export/import tables.

I am sure that there are lots of other ways that people try to get data refreshes - just keep your eye out.


4 views

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t