SQL Server 2000 hang and shrink won’t stop
Home > IT Answers > SQL Server > SQL Server 2000 hang and shrink won't stop
ITKE
10340 pts.
0
Q:
SQL Server 2000 hang and shrink won't stop
SQL Server 2000, SQL Database, Event Viewer
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
ASKED: Sep 29 2009  2:43 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46735 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Sep 29 2009  9:04 PM GMT by Mrdenny   46735 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0