Unfortunately now that it's in Emergency mode I cannot connect to any tables in order to update our live table's with a query. Is there NOTHING I can do?
I tried to run this:
ALTER DATABASE VPTest SET SINGLE_USER;
DBCC CHECKDB (VPTest, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
Alter DATABASE VPTest set MULTI_USER;
But STILL receive errors about the old log file. This is nuts.
Msg 5173, Level 16, State 1, Line 3
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
Log file 'V:\Program Files\Microsoft SQL Server\NewInstance\MSSQL\DATA\VPTest_log.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
Msg 5123, Level 16, State 1, Line 3
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'V:\Program Files\Microsoft SQL Server\OldInstance\MSSQL\DATA\Viewpoint_log.LDF'.
Msg 5024, Level 16, State 2, Line 3
No entry found for the primary log file in sysfiles1. Could not rebuild the log.
Msg 5028, Level 16, State 2, Line 3
The system could not activate enough of the database to rebuild the log.
Msg 7909, Level 20, State 1, Line 3
The emergency-mode repair failed.You must restore from backup.