x

Restore master database

Hi,can anyone tell me, What are the steps to restore a master database in sql server?

more ▼

asked Jul 07, 2010 at 08:27 AM in Default

avatar image

srivivek
535 41 42 47

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
more ▼

answered Jul 07, 2010 at 09:00 AM

avatar image

Kev Riley ♦♦
66.2k 48 63 81

(comments are locked)
10|1200 characters needed characters left

Follow what Kev suggested above(Start your server in single user mode and restore master database using replace). What I want to emphasis is when restoring system databases keep in mind you cannot restore system database backups to a different build of SQL Server.

more ▼

answered Jul 07, 2010 at 11:59 AM

avatar image

DaniSQL
4.9k 33 39 43

(comments are locked)
10|1200 characters needed characters left

Have you made a backup? If so how did you back it up and why do you wish to recover a backup?

more ▼

answered Jul 07, 2010 at 08:46 AM

avatar image

Ian Roke
1.7k 32 35 38

thanks for reply, i got the full backup,and my system was crashed,now i am trying to restore all my databases on the newly installed sql server what should i do?

Jul 07, 2010 at 11:26 AM srivivek
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x302
x129
x18

asked: Jul 07, 2010 at 08:27 AM

Seen: 1494 times

Last Updated: Jul 07, 2010 at 08:27 AM

Copyright 2017 Redgate Software. Privacy Policy