I bet it's configured there by default

run the query on both servers :

SELECT *
FROM sys.configurations 
WHERE...

The thing is, SELECT * from a table without a where clause is just a test of server settings, database settings, load, contention, and hardware. It's not anything else. There's...

Did the recovery model get changed and the logs are now huge?

Just piling on here.

When comparing the performance between two systems, we have to know that every possible thing is identical before we can say "See, SystemA is sucky and SystemB...

Yes. If anything has changed in the structures such that the forced plan is no longer valid, it'll just get ignored.

I strongly recommend just focusing on the point in time recovery as your mechanism. It's easy to set up. Completely supported in every way. You won't have to do anything...

Whoa! Hold on a sec....

Restore to a point in time. That's all you have to do.

You can't take a full backup without transactions. It's fundamental to the recovery aspect so that it can successfully restore without corrupting the database. Not only do can you not...

...

You're all still here?

Go home.

(btw, hate that movie, but it's a good quote)

You're all still here?

Go home.

(btw, hate that movie, but it's a good quote)

If I misunderstood, I apologize.

What you're saying you want is a separate database to use for reporting. That separate database will consist of data from a bunch of other databases...

This is a problem I am going to have to deal with soon. In most of our dev data, it doesn't need to be realistic data and our options...

Have you looked at Dynamic Data Masking in SQL Server? https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-2016 Not sure what you mean by "custom built scripts". You don't need to write any extra scripts to...