presumably the steps are

1. backup on source server

2. ZIP dump file

3. push [source] or pull [target] to target

4. unZIP dump on target

5. restore dump on target

what you imply is that...

I notice in the banner for the site an advert for

http://www.sqlzip.com/

perhaps you should trial that ?

0. pick a quiet time for update and get Management to buy-in

1. backup all databases

2. backup the server (with Std Ed)

3. ensure adequate headroom on system db's (especially master, msdb,...

The @@IDENTITY returns the most recent value used to insert a row. Your problem is that your journal table has an IDENTITY column so the value returned is that secondary...

I seriously recommend that you create a separate FILEGROUP (say BLOBGROUP) and use the

CREATE TABLE table_name ( ...) ON DEFAULT TEXTIMAGE_ON BLOBGROUP

this means that the physical storage of blobs is...

Assuming your table is not Clustered already, the operation to effect a CI is major because it will require a physical reordering of all data, and all existing indexes will...