I know that this is a long time ago, but I thought I'd...

Breaking the recovery chain was the thing that made me a bit jumpy. I do a full backup directly after finishing this job to start the chain back up...

Answering in order.

The log file for this one database does grow huge, only when running a RE-INDEX. After I've cleared the log file down (by switching to "Simple" Recovery...

Hi,

Thanks for your replies, I appreciate you taking time on this.txtPost_CommentEmoticon(':)');

The issue is three-fold.

First, it eats diskspace for backups. Because the log fills with these "Status 2"...

Sorry, been doing non-computer things!

"Status 2 Files" are rows within a DBCC LOGINFO command that have a status of 2, and as such do not clear down. As described...

I would also like to know of any reasoning or experience. I have two SQL2000 servers running SQL_Latin1_General_CPI_CI_AS and Latin1_General_CI_AS* with differing speeds including Optimization and general querying. ...

Okay, finally managed to get back onto this.

Within Stored Procedures was where we first noticed the issue. I've done some extensive testing looking at the different strings used to...

No, I get the data fom the local server.

To clarify, when running this

select * from remoteservername.databasename.dbo.tablename

I do NOT get the data from the remote server I get results from the...

Okay, sorry with context already I my mind, I can't be explaining very well.

Simply put when I run a query like

select * from servername.databasename.dbo.tablename

I do NOT get the data from...

Yes, I'm using servername.databasename.dbo.tablename for both queries.

Both servers just return data from their local table, whatever the servername is in the above 4-part name.

Both still using SQL...

Oops, for some reason half the important bits of the email disappeared! I'll try reposting without some items that might get misread. Assume square brackets round everything and...