> Hello, all!
>
> Last week I had a big problem in my DataBase Environment. My master
DataBase
> became corrupted and I couldn't start my SQL SErver again.
> The problem was caused by NTFS Corruption in Drive C:\ on Windows 2003
Server.
> I tryed do solved it using Scandisk but it didn't work fine.
> After that, I re-installed the server with Windows 2003, SQL Server 2000,
SQL
> SErver 2000 SP3 and other two Hotfixes. The same status than before server
re-
> installation.
> Then, I atached my storage disks again in my server, I gave the same
volume
> labels and letters for it and tryed to start my SQL SErver using the same
> master database that was running before NTFS corruption. To made it, I
> changed the master database files paths directly in registry keys.
> During the SQL SErvices restart, I received the following error message:
>
> The LSN (XXX) passed to log scan in DataBase is invalid.
>
> I tryed to attach my master dataBase using the sp_attach_single_file with
> another name, but it didn't work. After that, I made the following
procedure:
>
> - I attach my master database using another name and using other logfile,
> this database start in suspect mode.
> - I changed the database status for emergency mode
> - I export all information (just tables and schema) to another Database,
but
> the data that was exported is too strange for me. There are no System
Tables,
> System Stored Procedures, etc.
>
> Anybody knows if this procedure is used just for user database?
>
> Thanks
>
> Juliano Horta
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1