November 17, 2006 at 11:04 am
In some cases, other databases are crashed. Is it possible to start SQL Server with only master database, and then, we can recovery other system and user databases?
Many thanks in advance.
November 22, 2006 at 7:07 am
Yes, there are some help for doing 'admin' starts, presumably used from a command prompt.
start the sqlserver service from a prompt and use some or a combo of the following options;
/m starts in single user mode
/f starts in minimal configuration mode
/T3608 starts and only recovers master
BOL has more info on startup parameters.
/Kenneth
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy