PLEASE Disregard my post.

I found the issue.

Thanks

Thanks for the response.

It looks like I can get rid of the issue by using smalldatetime instead of datetime.

Regards

Michael Hilligas

Thanks.....That is a solution.

I thought there was a way to close and deallocate manually.

I may be wrong.

I have already fixed it.

Take care

Regards

Michael Hilligas

Thanks.

It Works Fine

Regards

Michael Hilligas

WELL... I spoke to soon.

It has gone back into recovering.

I will let it go for a while and see.

GilaMonster...

I am the most blessed man on earth.

The DB came back online and my application can connect to the DB.

All the config data is there.

I think I will make a...

GilaMonster....

is_auto_close_on = 1

Recovery model is simple

Not sure how to check dataloss allowance

Thanks for helping me

Michael Hilligas

GilaMonster...

I just ran the query again and it now says the DB is RECOVERING.

I imagine I should bide my time and see if it recovers.

Michael Hilligas

I have done quite alot of SQL work, but have had little problems so my troubleshooting abilities are limited.

this database is a configuration database for a application program.

the application program...

The database is ONLINE

I was going to truncate the log file, but I cannot open a query against the DB

I have the query open.

what column will tell me the actual status.

AGAIN.....Sorry for my ignorance

Michael Hilligas

I got the status from the properties dialog of the database.

can you tell me how to query sys.databases.

sorry for my ignorance

Michael Hilligas

Thanks for the reply.

The status currently is (Shutdown, Normal)

which seems OK, but I cannot do anything with the database.

I just noticed my log file is 4.5 GB and this is...

Thanks for your quick reply!

I am installing from SQL2005 setup.

When it checks the system it warns me that in order to upgrade my existing SQL2005 I must use SKUUPGRADE from...

Thanks.....I will check this out.

Regards

Michael J. Hilligas