Jeff Moden does a good job of showing performance comparisons

http://www.sqlservercentral.com/articles/T-SQL/63681/

The way you do this is to schedule full, then diffs, and then log backups. You take a full and restore it to the new instance. Once that is done,...

Jeff Moden (8/24/2014)

---

Steve Jones - SSC Editor (8/24/2014)

---

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do...

Side by side for me, but always make sure you take backups of all user databases, master, model, and msdb before you do either.

Added "functions" to the QotD, though I think you're being a bit pedantic, Tom.

You can't use a variable in the FROM clause.

However if this is for something like masking data on restores to dev/test, and isn't run often, you can use dynamic-SQL

declare @cmd...

Closing this thread.

Please post replies here: http://www.sqlservercentral.com/Forums/Topic1606742-3411-1.aspx

Please don't use all caps. It is equivalent to yelling. Also please don't cross post (removed the other one).

You don't want to do this in SQL Server. Use Windows at...

That's a...

Boy, I Miss Lucy, :-P:-P:-P:-P

I had fun trying to come up with plausible incorrect answers.

Developing and (some) testing against a subset doesn't mean that you never use production data, or even greater-than-production sized sets. It means that you do lots of your development against...

Finally, things are working. A debug item slipped through into production (apparently).

Let me know if things are still broken.

I see it. We'll review as soon as we can

Yep, reported and people are looking at it.

Either we had some injected code or someone deployed something they shouldn't have.

:(, you took away my pictures