![]() The current database is switched to master. See the SQL Server errorlog for details.įailed to restart the current database. The log cannot be rebuilt because the database was not cleanly shut down.ĭatabase 'EmergencyDemo' cannot be opened due to inaccessible files or insufficient memory or disk space. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\EmergencyDemo_log.LDF" may be incorrect. I’m assuming there’s a database called EmergencyDemo that’s in the same state as at the end of the second post I link to at the beginning of this post: the database has no log file, is in EMERGENCY mode and the salaries table is corrupt.įirst off I’ll try bringing the database online, just to see what happens:ĪLTER DATABASE SET ONLINE įile activation failure. Let’s walk-through an example of using it. I have seen it fail several times in real customer situations. And if it does? Probably time to update your resume for not having a water-tight backup and disaster-recovery strategies in place. I always advise taking a copy of the database files before doing this in case something goes wrong or there are unrepairable errors. It’s a one-way operation and can’t be rolled back.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |