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.
[Br class="height5" />[small]
SQL Server 2000
September 29, 2009 2:43 PM
September 29, 2009 9:04 PM