 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008SQL Express on PC doesn't start after moving to domain - The log s
Hi, I have a PC that was in workgroup mode. It has SQL Express installed on it supporting one application. I recently moved the PC into a Windows 2003 domain. Now SQL Express is not starting and is showing the following message: "The log scan number (204:440:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. " Any ieas Hi Michael It looks like the log file for the master data is corrupted. It is unlikely this has occurred because you have added the machine to a different domain. Did you copy these files? Check the filesystem is ok! Make sure there is nothing in the event log relating to disc problems. If you have a recent backup of the master database you may want to restore it (as a different name) on another server and then copy the mdf and ldf over. Use the start up parameters if you want to put these in a different location. You may be able to attach the old master database and rebuild the log. You can also use the installation option REBUILDDATABASE to create a new master database http://msdn2.microsoft.com/en-us/library/ms144259.aspx#rebuilddatabase John > Hi, > I have a PC that was in workgroup mode. It has SQL Express installed on it [quoted text clipped - 11 lines] > > Any ieas I ommitted to mention this machine is Vista Business. I don't see how the Master database could become corrupt - its a relatively new machine / install. Could it be anything to do with Vista / security ? > Hi Michael > [quoted text clipped - 33 lines] > > > > Any ieas Hi Michael The message you had was about file corruption, whereas security would give you file access type errors. You may want to check any Anti-Virus software is not scanning the files. Have you made sure that the disc isn't corrupt? Even new machines can have faults. John > I ommitted to mention this machine is Vista Business. > [quoted text clipped - 40 lines] > > > > > > Any ieas |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.