SQL Server 2000 hang and shrink won’t stop
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
Software/Hardware used:
SQL Server 2000
ASKED:
September 29, 2009 2:43 PM
UPDATED:
September 29, 2009 9:04 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
