Yes, it helps a lot, thanks...

What I did was user the sp_trace_setstatus command to stop it (I didn't delete it). I then moved all those trace files over to...

Well, for now I have moved about half of those trace files over to the data volume - there's lots of space there. However, if running this trace isn't...

I don't see anything in the startup folder. When you say "maybe it's a service" are you referring to a Windows service (services.msc) or is this also a SQL...

Thanks for the quick response. Here is the output from your query:

1,1,2

1,2,C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_30.trc

1,3,20

1,4,NULL

1,5,1

2,1,2

2,2,C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf..2009.02.12.10.32.51.trc

2,3,5

2,4,NULL

2,5,0

3,1,2

3,2,C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf..2009.02.12.10.34.57_5197.trc

3,3,5

3,4,NULL

3,5,1

The file referred to in traceid 2 (the first...

Wow, nothing...

Even a link to a concise previous discussion would be helpful.

Thanks,

Thanks,

I will try that - backing up to a local folder, then using ntbackup (or backupExec) to send it to the backup device.

I appreciate the quick response.

However, I do want...

This is all crazy stuff - I have never heard of any of this stuff before now, even though I have a number of clients running something or other on...

Thanks, David.

It sounds like a sensible plan - can the database and TLog be shrunk using a Maint. Plan, or should I figure out some way of using a...

With the very little I know about databases in general, and SQL specifically, I just have to take it on faith that there's a reason that everything related to SQL...

Yes, we are using Veritas at this site as well (also at another site with a SQL datatabse).  I am having a hard time learning how to properly protect their...

This is one of the many things I find confusing about all this:  I was doing a full backup daily, yet the Transaction Log grew to about 8 GB -...

Leave it to Microsoft to bundle two products together that don't play well together!

Funny how their accounting application (over 6 GB in size), also SQL based, performs normally through all of...

This post is getting quite long, so you may have missed all that:  as GilaMonster points out, the production machine has never had MSDE installed on it.  So there's no...

Because I was tired of being a total dunce, I decided to play with this stuff a bit on the bench instead of going to a client's site and learning...

I have recruited a local database designer to assist me with this.  SQL Profiler looks like a powerful tool, but you wouldn't put a grenade launcher into someone's hands unless...