Thanks Kevin, that's why I am looking for the culprit. I know it messes up recovery if it's needed. I'm not having my name be tarnished on account...

Thanks Jeffrey. I'm looking into the hooks from 3rd party software. It's like a hunt and peck because the people who set this up have left and others...

Thanks again. I'm turning it over to the users for testing now so we will see what happens. Let's keep our fingers crossed! 😀

Hey there. Thanks I ran method 2. Thank God I was doing a simulation test. We set up a scenario that would mimic that actual cutover. ...

Hey, Is it safe to assume that method 2 will for work going from 2000 to 2008? It looks like it will work going from 2000 to 2005 but...

Hey Jeremy,

I read that article once before. My question/problem is this....the Drives of the old server where the sql 2000 master and user databases are located is being disconnected...

Thank you very much.

Does anyone know if you can use sql server 2008 sp2 on a R2 installation? I just found the sql server 2008 sp2 is out.

Thanks. I thought about that as well and didn't have any additional steps in the sql agent jobs. The transaction log backups of all the databases including the...

Okay. Thanks I will try run another trace and try the fn_trace_gettable

@pradeep-2 Adiga

Thanks for the info. Do I use the standard trace template or is there another template that is better for tracing a truncate?

No transaction log backups are failing. I run a transaction log backup every 15 mins for all the databases. This transaction log truncate appears to run around 1:15...

Thanks Grant. I with you guys on this. Now I just need to figure out how to do that. I in know way consider myself an expert...

I am resending the attachment zipped. No it hasn't been confirmed that the SQL performance problems are caused by the disks. I am not sure how to tell....

I have attached a document with metrics. The H: drive is where all the MDF files are located. The I: drive is where all the LDF files are...