Can anyone shed some light on why: restoring a SQL 2K DB results in the database hanging at loading? I have tried 2 times to restore a database with the same results. The process will complete stating that the database restore process completed successfully, yet the status on the database is: "Loading" ???
Also, I've noticed that SQL Server creates a file named _BEVspCacheFile_0.TMP what is this file? Obviously, its some sort of cache file but when is it created? The file has not been modified for a few days now and its size is approximately 13 GB. I'd like to delete it, but want to make sure that I don't cause a problem in doing so. If I can delete it when is it safe to do so?