SQL Server 2000 hang and shrink won’t stop

352420 pts.
Tags:
Event Viewer
Microsoft SQL Server 2000
SQL Database
I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely. When click on Databases tree in MMC, it will hang. I check the Event Viewer Application log and found logs that run almost every 15 seconds since yesterday evening. It write "3455: Analysis of database 'db_name' (8) is x% complete (approximately xx more seconds). I guess it's because auto-shrink feature. So, how do I stop this in order to enter the Database and check the settings? Your help is greatly appreciated. Thanks. [Br class="height5" />[small] [/small]

Software/Hardware used:
SQL Server 2000

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your database is in the process of checking the database before bringing it online.

There’s no way to stop it. It’s going through the log committing completed transactions and rolling back aborted transactions.

You should NEVER detach the database and delete the log file. If you don’t need point in time restores then change the database from FULL recovery to SIMPLE recovery.

You should also disable the auto-shrink feature. This is just messing up your performance by fragmenting your hard drives.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following