Post reply

mssql 2005 will only come up in singlwe user mode

  • May 19, 2008 at 1:42 pm

    #123917

    I think one of my system database files is corrupted. I did an alter database... to move my Model and MSDB and now I can only start the instance with /f /t3608

    I can connect to the instance but I can't do anything I get an error that one of the database files does not match it's primary file.. I don't know if it's MSDB or MODEL but I pretty much can't do anything.

    I made a backup of model and msdb before I started.. how do I go about restoring them?

  • May 19, 2008 at 6:35 pm

    #817536

    Still can't seem to figure out how to restore my model and msdb databases?????

  • May 19, 2008 at 11:09 pm

    #817573

    I hope you follow this article: http://msdn.microsoft.com/en-us/library/ms345408.aspx

    Sopheap

  • May 20, 2008 at 3:33 am

    #817657

    Thank you. That is the article i followed and i must have messed up somehow.

    i can bring the instance up in single user mode but when I try to do a query to re-do my alter statements, it says i can't attach because only one seesion is allowed. in 2000 i used to be able to start query analyzer without starting enterprise manager.. can't figure out how to do that in 2005 Mgt Studio. I either need to reattach my files properly or restore model and msdb.. ?????

  • May 20, 2008 at 6:43 am

    #817812

    I tried starting the Instance from a command prompt

    sqlservr -c -m (minimal mode) so that I could restore model and msdb and it WILL NOT come up. I get an error saying that one of my files (either model or msdb) has a file that is incoimpatible with it's primary file.. any ideas?

  • May 20, 2008 at 7:55 am

    #817901

    i ended up starting the instance in single user (netstart mssqlserver /f /t3608), opening SSMS, cancelling the connect dialog and then opening a new query window and issueing my alter statements again to move the model and msdb files. little different than working with ENT manager and query analyzer!!!

  • May 20, 2008 at 9:19 am

    #818019

    Here's another article: http://msdn.microsoft.com/en-us/library/ms190749.aspx

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply