It should. You might need to restart the log shipping jobs, but they should be able to pick up with the next log file

That's the agent log, isn't it? You want to get something from the maintenance plan itself, not the job. Something like this:

Maintenance Cleanup Task (SEVENFALLS)

Maintenance Cleanup on Local server connection

Cleanup...

No, no red gates. Not unless they pay for it! 😛

My wife bought green last time.

Digging is easy here. I have an auger on the tractor. It does the work....

It is a nice break during the day. Course, I've spent 20 minutes out there 3 nights in a row with a bucket of water trying to soften clay and...

Still going...

Kit G (9/3/2010)

Yes, we are. I'll let Gus...

Just for load, I'd do them in series. As noted by Jason, I have no metrics.

I'd also use shrinkfile instead of shrinkdatabase. Had better luck with that.

OK, Lowell's theory works for me. I can re-enable a constraint, with CHECK, and it succeeds, even if I have data in the table that conflicts with the FK.

That seems...

Is this the add of a constraint and not a re-enable? Did you disable it for some reason? What is the constraint?

I don't think you are supposed to be able...

In addition to the other notes, if you have file system access from the Windows server, you can bcp out (or SSIS export) the data to a file that you...

Are you post SP2 + SPs? There were some fixes for plans.

What are your deletion settings?

Be safe, hope no major damage.

You can run a SQL 2000 database on a SQL 2008 server in compatibility mode 80. That might work for you.

Not sure if SQL 2000 can run as a named...

Kit, are you and Gus near Tampa? I heard Jonathan Kehayias was looking for a DBA, paying well.

IF it's eval edition, you can get info here: http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html

If you want to query each server, I'd think that eval edition had a note in the @@version that it was...