In the second step, you restore the master database together with all other databases using the last full database backup. Although the use of this command is more difficult, this approach allows you to restore the master database in the most cases. Of the two ways to do it, my favorite is to use the command window and execute the sqlservr command (from the command prompt) with the option –m. To restore your master database, start your instance in single-user mode. If you can’t start your system, then you must go the more difficult route and use the sqlservr command. The easier way, which is available only if you can start your database system, is to restore the master database from the full database backup. Two different ways exist to restore the master database. Execution of the DBCC command points to such a failure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |