its a bug with the monitor. Create a job to insert a trace token every so often start with every day and move down from there. Depends on the amount...

make sure tempdb has enough spindles to handle the IO - once you have that you should have 1 tempdb data file for every cpu you have up to 8....

if you do this you have to make sure you have enough memory on each individual server to handle all 4 instances and any OS commands in case of a...

well I agree you do not need the diff backup but if you want to be 100% forsure you covered all basis I would keep it:-D

running the below alter DB restricted user will make sure all transactions have been completed before the detach. Running something like the below will make sure you have as little...

Well I guess it is my opinion that replication is not the place for archiving (Datawarehousing) as far as writes to the disk. Yes it would be the same as...

Assuming you have a domain user running sql server agent service. Then can you have permissions granted to that user?

Few questions:

Is the data set returing NULLs? Is there logic for the fields in the report after the data set is returned? The fields that are blank what data type...

Have you tried to edit the job from SSMS? assuming it is a SQL standard maintenance plan.

I would not suggest Transactional replication for a datawarehouse. It would be an administrative nightmare. Not to mention getting your data out of the datawarehouse. If the data is written...

Have you contacted Microsoft support?

write a stored proc that pulls from sysprocesses and logs the spids running. If the spid runs to long execute the kill command. You could run this stored proc every...

Run a standard trace and write to a table. Once the error occurs check the table around that time to see what is going on. You could also extract which...

no it is a good way to do it. Make sure you update the compatibility level to 10 after the restore.

To make sure you will not have a problem run...

The best idea for reporting of this data is to create another dimensional model database with a star scheme that is populated from the large database then generate a cube...