Anybody have any clue what might be causing my SQL 2000 Enterprise 64-bit,
Windows 2003 R2 SQL Server crashed and failed over during a manual grow of a
database file? It has happened twice now.

--
DB

"DB" <DB (AT) discussions (DOT) microsoft.com> wrote

Wow, a 10 year old application running on a 7 year old operating system. <G>

I can only guess, without seeing all of the logs and have access to the
systems, but I would guess that the database grow process it taking complete
control of the disk and causing the failover. This happens, for example,
when doing a chkdsk as well. You should use extended maintenance mode during
processes that need full access to the disk.

http://support.microsoft.com/kb/903650/en-us

Good luck the next time around.

--
Russ Kaufmann
MVP, MCT, MCITP x7, MCTS x9, MCSE x4, CTT+
ClusterHelp.com, a Microsoft Gold Certified Partner

Email:russ (AT) clusterhelp (DOT) com
http://www.clusterhelp.com
Blog: http://msmvps.com/clusterhelp