<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Performance Tuning
»
How to restore master database.?
How to restore master database.?
Rate Topic
Display Mode
Topic Options
Author
Message
Joy Smith San
Joy Smith San
Posted Sunday, June 28, 2009 11:43 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:21 AM
Points: 1,371,
Visits: 2,300
what are the steps to restore master database..?
Thanks.
Post #743363
hi_abhay78
hi_abhay78
Posted Sunday, June 28, 2009 11:58 PM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267,
Visits: 385
go to services >> double click the SQL Server service>>
stop the service >> type "-m" (excluding quotes) in the start parameters and click on start (do not click ok) >> open the SSMS and give this command :
restore database master from disk='
' with replace
stop SQL Server remove -m and start it again .
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #743370
Eswin
Eswin
Posted Monday, June 29, 2009 12:11 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 4:19 AM
Points: 1,593,
Visits: 1,025
Abhay
Will all logins , users, roles will be restored.
Should be restore the user database before master , model and msdb if a server crash occurs and you are creating an new environment using the backups save from the crashed server.
Tanx
Post #743374
hi_abhay78
hi_abhay78
Posted Monday, June 29, 2009 12:42 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267,
Visits: 385
all logins , users, roles will be restored from the pervious master backup .In case you more logins/users created after the last master backup , then you need to script them out using : http://support.microsoft.com/kb/246133/ and http://support.microsoft.com/kb/246133/. Go through them carefully and you will get everything related to all the versions (except 2008 as of now).
Restore the user databases after the system databases.The reason is you cant restore the user databases if your system databases are not up and running as the instance will be down.
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #743384
Eswin
Eswin
Posted Monday, June 29, 2009 1:08 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 4:19 AM
Points: 1,593,
Visits: 1,025
If we restore the user databases after the system databases how will we know which database the user is mapped and what role he has.
Tanx
Post #743394
Eswin
Eswin
Posted Monday, June 29, 2009 1:11 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 4:19 AM
Points: 1,593,
Visits: 1,025
hi_abhay78 (6/29/2009)
all logins , users, roles will be restored from the pervious master backup .In case you more logins/users created after the last master backup , then you need to script them out using :
http://support.microsoft.com/kb/246133/ and http://support.microsoft.com/kb/246133/.
Go through them carefully and you will get everything related to all the versions (except 2008 as of now).
the second link..........
Tanx
Post #743395
hi_abhay78
hi_abhay78
Posted Monday, June 29, 2009 1:48 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267,
Visits: 385
So this is what you need to do :
-> restore the system databases
-> restore the user databases
-> run the script in master for rest of the users/logins creations ...
makes sense ??
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #743401
Eswin
Eswin
Posted Monday, June 29, 2009 1:52 AM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 4:19 AM
Points: 1,593,
Visits: 1,025
.
Tanx
Post #743403
SQL Swerver
SQL Swerver
Posted Tuesday, January 12, 2010 3:02 PM
Valued Member
Group: General Forum Members
Last Login: Today @ 3:24 AM
Points: 67,
Visits: 350
The problem is you cannot connect to the SQL Instance using SSMS when it is running in single-user mode?
Post #846578
myoleherrera
myoleherrera
Posted Monday, January 18, 2010 2:21 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, March 02, 2010 11:32 AM
Points: 1,
Visits: 5
Yes you can connect to SSMS while in single user mode. Before putting your server into single user mode, make sure you have a proper user account set up or use the sa account to log in. The real issue is that you cannot restore the master database using the query stated earlier.
Myole H.
SQL DBA / Report Developer
Post #849403
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
