If you plan to uninstall and fresh install, keep in mind you will have to list out plenty of things before you uninstall.

Script out SQL Agent Jobs, Linked Servers,...

Agree with the previous users opinions on installing, it would be a better way..

If you are planning to do a in-place upgrade, then I don't think you cannot upgrade 2...

Also consider if you are going to have new indexes on one or more columns (may be startdatetime or login name etc)..

Good to know, glad to help..

You are still seeing only 1 row when you try from your workstation ssms? If so, have you tried closing down ssms and open it afresh..

Since this is not a...

Looks like you are storing a trace information in that table..

It is you who has more information than any one..

By that what I would say is, try doing...

ahthomas (2/8/2012)

---

I know I can right click a folder under registered servers and do a query. How do I query all of these servers in one breath for any warnings...

From what you explain, I would suggest you to look at Transactional Replication..

Then you can try this, run a trace without filtering the application name and run a simple top x query from SSMS. Stop the trace, it should have captured that...

If that returns more than 1 record, it should then display you the same number of rows in database properties (when you select files page)..

Can you ensure you close...

Run the below script and see what you get..

SELECT * FROM MASTER..SYSALTFILES WHERE dbid = DB_ID('Database_Name')

Replace Database_name with the database that you are...

Yes you can..

Explore the following possibilities..

Replication

Log Shipping

Database Mirroring

Though each of them have its own advantages and disadvantages to choose from.. Once you know more about them, you will...

I have not said that they are mutually exclusive...

It is...

At first, I thought the same as Gail mentioned but after looking at the schedule for the 2nd time, I am assuming whoever has created the Maintenance plan and...

Looks fine.. Looking at the schedule, I am guessing the database is not a very large database..

All in all I don't see any problems with that schedule..