But that's not partitioning...

Just to be sure to be sure to be sure 🙂 (because it would be a cause of this), what does RESTORE HEADERONLY return on one of the backups showing...

You're absolutely sure there aren't somehow multiple backups appended in the same file? (since you're using noinit on the backup)

What are the exact versions of the two servers?

SELECT @@Version

Any traceflags enabled on either server?

There's only one backup in that file? Not multiple appended somehow?

Go back until you find an error log that has the startup details in it, that one is a re-initialised log.

Why do you want to do that though?

SQL manages its own memory well. You don't need to 'clean' memory out. All you're doling by running those commands is making SQL...

Hmmm... that's odd.

Should created the DB exactly as it was at the time of the backup. Nothing else going on? No reverts from snapshot? No data obfuscations being run?

Can you...

You've got traceflag 1222 turned on.

You can turn it off with DBCC TRACEOFF, but depending on how it was enabled it may come back.

Can you post the first 15...

The message has nothing to do...

You said the production DB has initial size of 15GB, what's the actual size of the data file on disk?

Edit: Native backups? What's the backup command? What's the restore command?

Can you post an example?

Unlikely. SQL is quite capable of handling a hard shutdown. Something has gone...

There's nothing in that predicate which will force...

jjturner (3/26/2014)

---

Now I’m guessing that with Instant File Initialization turned on, it may simply be allocating the new space rather than going the extra step of 0-filling. Time to...

As general good practice, you should update all stats (with fullscan preferably) and run CheckDB after any version upgrade. Absolutely necessary, no. Avoids possible later unpleasant surprises, yes.

As for the...