Differential backup in their own sub-plan\maintenance plan.

Transaction log backup in their own sub-plan\maintenance plan.

Yes - only user databases. No reason to do anything else with system databases other than...

JamesNZ (3/23/2009)[/bVery good point. Just to check my thinking, if I'm taking a full backup every night at 9pm, I can delete all differential and transaction log backups that are...

By including the columns from the outer table in your joins, you are excluding any rows where there are no matches. This is the same as if you had...

Nothing I've ever seen - and you should not have seen in the 08 instance. My guess is that one of the instances was not started.

That really depends upon your business, but what would happen if your boss came to you and said that you need to restore the system back to yesterday at 8:50pm,...

Are you sure you did not upgrade the third 05 instance to 08?

Have you verified that the databases in the 08 instance that you are seeing are the same files...

You supplied the original query with the column defined as [date]. If you don't have that column available, what do you want the [date] column to be?

I am guessing...

Also, you can add a backup log operation (full recovery) or checkpoint (simple recovery) for each iteration to reduce growing the transaction log too much.

I don't think the first query is working the way you think it is. By including in the where clause any column from the tables you have left...

Read the article I link to in my signature to find out how to post your question so it can be answered better/faster. What you are looking for is...

Thanks for the update.

In addition to what Steve has outlined, you are going to have to disable/drop foreign keys before you can recreate the tables. And, don't forget to script the indexes...

mgrammer (3/23/2009)

---

Thanks everyone for the help. It looks like it will not be a simple fix :crying: .

Even though I still have the tables stored on our SQL 2000...

Yes - it does seem to be related to SQL Server 2000. I just tried with one of my 2000 boxes and was prompted every time I opened a...

mgrammer (3/23/2009)

---

Thanks Steve.

I went ahead and ran that statement. I'm assuming that will prevent any future tables from being marked as system, but unfortunately the existing tables did not...