are you sure this is the correct command? This gave me a long listing of many systems.

but how would I do the following?

2. How would I ceate a job to remove old trace files like on daily basis?

Sorry that does not help.

I really would like to know the following:

1. How are the audittrace* files getting created? How would I configure to...

That is the problem I cannot add any more files to the primary group since the thresehold has been met on that, that Is why I was trying to create...

So it means if was able to create a secondary filegroup it still would not solve my problem in regards to database objects growing? New objects could be created in...

Now I have a new problem. I created a secondary filegroup and I tried to add two datafiles to it and it gives the following error below after the syntax.

USE...

But as I indicated I had old backups from up to 4 days ago. I do not believe disk space was an issue in the last 4 days.

Thanks, this I understand I was hoping for a magic SQL summary statement for the database rather than running 684 selects

I found the following, however I do not believe this applies to what I am looking for:

Login time-out (seconds)

Specify the number of seconds to wait before the instance returns...

How do I find information on "Multiserver Administration" on bol? What is bol?

How do I query the name of the sqlserver from the database?

ok please specify which tables/views hold the information I need for the following?

SQLServer Name

Database Name

Backup Type

Backup Status

Start Time

End Time

So it means I can create the report by pulling the data I need from one sqlserver?

How do I get the data I need for the information specified in...

I would like to get the following report daily for all of Sqlservers we take backups for.

Let me give an example of an email report I am looking for:

SqlServer       Database Backup...

no