Hi!
My SQL Server 2000 suddenly stopped running few days ago that's the first time I have ever had this situation. I tried to restart it but failed. I then checked the error log and found the below message.
17052 :
Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I'm pretty sure that the disk space is still very large with about 30GB.
Well since I could not run the "Enterprise Manager" then I just try to copy the 'model.mdf' and 'modellog.ldf' from the backup server and this made the server alive again.
Though seems that the problem has been solved but I wonder is the 'model' database still stable. How can the 'model' database be ruined? Any prevention of this happen again?
Thanks!
My SQL Server 2000 suddenly stopped running few days ago that's the first time I have ever had this situation. I tried to restart it but failed. I then checked the error log and found the below message.
17052 :
Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I'm pretty sure that the disk space is still very large with about 30GB.
Well since I could not run the "Enterprise Manager" then I just try to copy the 'model.mdf' and 'modellog.ldf' from the backup server and this made the server alive again.
Though seems that the problem has been solved but I wonder is the 'model' database still stable. How can the 'model' database be ruined? Any prevention of this happen again?
Thanks!