I have 31Gb database that I have just set compatibility mode from 2008 to 2000 by first etting to single user mode then running:
ALTER DATABASE dbname SET COMPATIBILITY_LEVEL = 80
and it has been running for 10 minutes. Is this an action that usually takes a significant time period to complete? The server is a virtual server (a test server) and was low on memory. During execution I deleted some files to free up space. The command is still executing.
is this normal? Would it be faster if i had used the EXEC sp_dbcmptlevel dbname,80?
TIA
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;