Browse by Tags

Recover a database with no transaction log file - SQL Server 2005!

Published 11 November 8 1:16 AM | SqlServer-QA.net

Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that...

Filed under: sql server, ssms, error log, suspect, 2005, corrupted, detach, attach, dataabase

SQL Server Error 4616 - You cannot perform this operation for the restore database

Published 11 December 7 2:47 AM | SSQA.net

You may be aware default 4 SQL Server system databases master, model, msdb & tempdb are created automatically when the SQL Server is installed. Those databases files can be located under default directory assuming C:\Program Files\Microsoft SQL Server...

Filed under: sql server, database, error, error log, resource, attach, .mdf, 4616

"Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid

Published 17 September 7 4:44 AM | SSQA.net

Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'...

Filed under: sql server, error, error log, hardware, log file, detach, attach, data files, 9003, mdf