Backups have nothing to do with index fragmentation. Backups don't care about fragmentation, they don't try to decipher any of the pages. All a backup does is copy data from...

Is the hardware identical?

Are the server settings identical?

Is the data identical?

Are statistics up to date on both servers?

No to any of those could be the reason for the difference.

Either the backup was damaged in the copy and hadn't been taken WITH CHECKSUM or the IO subsystem corrupted the database during/after the restore.

Probably not. Got any backups?

Where is it showing 4GB? What are you checking, looking at or running to get the size of the file?

No.

Check that it's scheduled, check that the settings are correct, check that it's actually...

A snapshot size cannot be larger than the database it's a snapshot of. Hence why I asked how you're checking size and what values you're looking at where.

Ed Wagner (1/29/2014)

That sounds seriously unpleasant - that's...

How are you determining that?

Could use some of that chill down here. We had a couple of weeks of 35 C+ (high for JHB). Seriously unpleasant.

Why do you...

Msg 8106, Level 16, State 1, Line 5

Table 'ChildReferrals' does not have the identity property. Cannot perform SET operation.

Msg 8106, Level 16, State 1, Line...

No. The error is, as the error message said, "Incorrect syntax near the keyword 'CONVERT'.", not near the keyword PROCEDURE

Have you opened up the job and looked at exactly what it does?

Have you tried the code?

If so, does it do what you expect?

If not, what does it not do (or what error does it throw)?

Edit: Duplicate thread, please rather continue at...