Ok I found log_133.trc its 11mb in size. Now how to I use it / load it?

I never knew about a default trace... I will check into it. Thanks!

Ok slow down... So I need to start a trace? How long should I let it run?

Ok thanks guys! Unfortunately I think we have several other servers running the same version. I let our system admins know about it to see how they want to move.

Thanks. Have you heard of this issue before? I imagine it has something to do with RTM.

Sorry UDP you are right...

This is a highly transactional db and we do need to keep it in FULL recovery mode.

Thanks!

Yes, I thought upon truncating the transaction log file automatically shrank. I now know better. I did however go into the database properties and set the AUTOGROWTH MAX file size...

I should probably state the problem I am having...

I have several databases where the transaction logs are several GB in size and getting ready to use all the space on...

Ok please tell me if I understand this correctly...

In Full Recovery mode, you have take a Full backup to which transactions will be pilling up on a transaction log. You...

Gila,

The Database is in Full Recovery mode.

When I first connected to the instance I saw two maintenance plans. A full database backup and a transaction log backup. So if it...

We are experiencing some issues with the Tivoli backup client tool on some of our servers and I get the impression that fixing Tivoli is not a major priority as...

Oh I see. It's a built in function where you specify what property of the function you want to run on a specified database.

Thanks. I am not planning any changes to any production systems, it was just a thought that I wanted the answer to.

Ah so would that explain why I could only run my 2000 script to get the backup information on it.

Does this have any effect when performing a restore? For example...

Thanks Gail! I found a wealth of info and already tweaking it now for my use. I really appreciate it!