So I'm continuing to play with this archive process, copying a whole lot of records from the source table to a "ARCHIVE" suffixed table of the same name. All indexes...

I did the checkpoint thing also, several times. It was so strange. The Tlog got over 4G and I abandoned the attempt, proceeding with a restore, since it would not...

From what you posted, it looks like it is contiguous, but the logs in th emissing area just didn't have entries. This though, is curious since you should have backups...

I found this info in SSMS, by right-clicking the DB name, choosing Reports>Schema Changes History. I don't know how long the info stays in there, as this is from the...

So the first thing I wonder is if you have any control over what order the data comes into the DB when it gets reloaded. If you could dictate the...

How wide is the table? Can you post the scripts for the tables and indexes involved?

What are you keying on in your join?

How many records does the query...

I have run into this mysterious behavior myself, and never found a clue as to why it would happen. I had a production server that would be found with RS...

Yeah, what mazzz said. If you defrag the clustered index on that table it reorganizes the data in the table because the data in the table folows the order of...

If I read your initial post right, it sounds like you only need to do this once, since the SID on Prod will not change and once you have it...

Here are a couple of possibilities.

1. Set up DB mirroring from primary to DR server. If there is a primary server failure, make the DR server the principal and rename...

If on 2005, and DB compatibility Level is 90, Right click the DB name from SSMS, choose Reports, Standard Reports, then "Backup And Restore Events", for a nice report with...

The only way I know of getting this info is if you had some kind of trace going on the box at the time the query occurred. You may be...

There ARE situations where denormalizing data is prudent. Data warehouses are one, and in my opinon, this is the other. The "CompletedSales" table, containing sales that are completed and wil...

Nicholas,

I stole your strigger. Thanks.

I did put your name in the source so I can remember where I got it from.

Thanks,

Chris

Have you set up logging to a file in the job step's logging tab? This could be useful in getting more information about where the failure is. It could be...