Thanks very much both.

I'm amazed I've not seen this before

Hi Jeff,

Thank you very much for the reply. I fully expect to find that 'something' was changed somewhere, but I/they haven't come up with anything yet.

I wasn't aware of lightweight...

Hi Jeffrey

Thank you for the reply.That

makes sense, and is what I hoped the case would be.Does

SQL Server record anywhere that it has this memory, but isn't using it for anything?

Thanks...

if anyone else encounters the same problem (or more likely when I get the same problem again in the future), the solution was that i didn't have the path to...

Thanks Anthony,

I'd gone with the Linked Server initially, but didn't really like it.
Someone had told me that it may be better to use sp_dropserver and sp_addserver to...

Hi Anthony,

Thanks for the quick reply.
So it seems that my environment is set correctly at the moment. sys.servers has SQL-PRI on my primary node and SQL-SEC on...

thank you very much as always

Hi,

Thank you for the quick reply.
I was definitely confusing LSN's and differential bases there. sorry.

So, just to be sure, there's no problem with a very...

sorry.
 i missed your last post.

The DBCC repair_rebuild didn't help this at all.
From what I've read online, this can only be resolved using the 2 methods I...

I'm aware of 2 options for fixing the problem.

1) The Supported Method: export all data, create new database, reimport all data
2) The Quicker (hopefully) Method: using DAC,...

Just to confirm.

The msdb.backupset table did show that there were transaction log backups that were taking the database offline (i.e. restoring state)

Those backups were being run by the standard SQL...

That certainly makes sense. I wasn't aware of a transaction log backups with norecovery, and had focused on it being a restore with norecovery.

I'm waiting for the server to be...

Hi Grant,

Thanks very much, that helps a lot.

Hi Grant,

Thanks for the reply.

The majority of systems that I see are very small, with minimal IO.

A few have SAN's, most others use internal storage, or even NAS for storage.

I'm...

I just tried that using the syntax below.

No change in the size of the table as reported by sp_spaceused

create unique clustered index [pk_CommitmentsForPosting] on dbo.CommitmentsForPosting

(GUID ASC)

with

(DROP_EXISTING = ON)...