Home Forums SQL Server 2005 Backups How to restore master database in a SQL Server 2005 Cluster RE: How to restore master database in a SQL Server 2005 Cluster

  • when restoring Master, I usually stop SQL Server and then start it from a command prompt

    from command prompt, navigate to the directory where the sql server executeable resides and start it

    sqlservr -m -c

    or for a named instance sqlservr -m -c -s instancename

    I then start open query analyzer or Enterprise manager and restore (don't open both.. that's two sessions : )