I recently ran a GP company DB upgrade on SQL05 - 5 companies made it - one 
did not.  I tried 2 more times and ran into this error each time:

transaction log for company ID full.  To find out why the space in the log 
cannot be re-used see the log_reuse_wait_desc column in the sys.databases?

How do I open that table in temp DB to view that column?

and it also states to remove the temporary table at the database level.

I opened a case with MBS to assist but still have no answers on how to get 
past these errors - has anyone run into this who can help me?

(The database was restored from SQL2k to SQL05 and the compat level was 
updated to 90 - so I dont think thats the cause?)

-- 
S Ibbotson
MCITP - DYN GP 10 

I increased the company transaction log to unliimited growth and the upgrade 
succeeded.

This thread is closed
-- 
S Ibbotson
MCITP - DYN GP 10 


"adatasys" wrote:

> I recently ran a GP company DB upgrade on SQL05 - 5 companies made it - one 
> did not.  I tried 2 more times and ran into this error each time:
> 
> transaction log for company ID full.  To find out why the space in the log 
> cannot be re-used see the log_reuse_wait_desc column in the sys.databases?
> 
> How do I open that table in temp DB to view that column?
> 
> and it also states to remove the temporary table at the database level.
> 
> I opened a case with MBS to assist but still have no answers on how to get 
> past these errors - has anyone run into this who can help me?
> 
> (The database was restored from SQL2k to SQL05 and the compat level was 
> updated to 90 - so I dont think thats the cause?)
> 
> -- 
> S Ibbotson
> MCITP - DYN GP 10 
>