I have been to that link when I first moved the packages but I got the answer I needed from this link, Thanks

http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx

This link answered my questions.

http://blogs.msdn.com/b/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx

What metadata am I updating and why?

Sorry about the typo on the title.

I am in sql 2005 (wrong forum sorry). Yes the log file needs to be decreased. Shrink did not work because the initial file size is set to the current...

Thanks you very much!

Thanks Perry!

I was able to get rid of the error by re-creating the subscription.

Thanks!

The memory consumption report has this for the buffer pool (allocated memory, virtual reserved, virtual committed).

MEMORYCLERK_SQLBUFFERPOOL440 (allocated)6,184,960 (reserved)4,001,640(committed)

Could I go with repairing just the tables? Either checktable repair_allow_data_loss or checktable repair_rebuild?

Here is the full output.

Msg 8905, Level 16, State 1, Line 1

Extent (3:2060072) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated...

Hi Everyone

I was able to copy the data from the corrupt table into another table the rename the corrupt table then name the new table the original name and create...

OK then my next questions is if I need to recreate the table due to corruption or I ran a repair and lost the most recent data in that column...

Thanks you guys for all of your help. It really helped to give me a good picture of the situation and my options.

Doug