There is another benefit of giving advice. I find that I actually understand something better myself when I try to explain it to someone else - like the thoughts become...

No, just used shrink option from the SSMS (2005)...

My concern is the huge disparity between the actual data in the databse (i.e. almost none) and the space is it taking up (1Gb)! Shrinking doesn't seem to have any...

My original disgnostic query:

SELECT object_name(i.object_id) as objectName,

i.[name] as indexName,

sum(a.total_pages) as totalPages,

sum(a.used_pages) as usedPages,

sum(a.data_pages) as dataPages,

(sum(a.total_pages) * 8) / 1024 as totalSpaceMB,

(sum(a.used_pages) * 8) / 1024 as usedSpaceMB,

(sum(a.data_pages) * 8)...

Sorry, msdbdata.mdf = 1,012,608 KB and msdblog.ldf = 10,752 KB.

Results from dbcc loginfo:

FileIdFileSizeStartOffsetFSeqNoStatusParityCreateLSN

22539528192 6870201280

2262144262144 ...

Have you tried dropping a token and seeing if it makes it through OK?

Replication can be fickle. Sometimes it seems reinitialising just doesn't work and we have to recreate the entire replication job again.

Sorry! bit new round here - will do...

Thanks for the advice - really useful stuff.

dave-488664 (10/14/2009)

---

1. Transactions are committed when the database command 'COMMIT TRANSACTION ' is submitted, OR after an implicit transaction completes (http://msdn.microsoft.com/en-us/library/ms188317(SQL.90).aspx)

OK - but *when* is this?! Should...