What are the mandatory system dbs to start the sqlserver ?

Question

Post reply

What are the mandatory system dbs to start the sqlserver ?

charipg

SSCrazy Eights

Points: 9888
More actions
March 16, 2012 at 12:26 pm

#254976

What are the mandatory system dbs to start the sqlserver service?
Master,model,tempdb and msdb all these are mandatory ?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Don't forget the hidden resource database.

I am curious why you are asking?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

charipg SSCrazy Eights Points: 9888 More actions · Answer 2

actual my doubt is

can we able to start sqlserver without msdb ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Yes you can. But you should have a backup of that database available so you can bring it back online. Sounds like you are in the middle of trying to recover from losing some system databases. Is that about right?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

charipg SSCrazy Eights Points: 9888 More actions · Answer 4

yes.. i have only master files..

my plan is to first start the sqlserver using with master db and later will restore the other system dbs.

rraja Default port Points: 1486 More actions · Answer 5

here is the steps

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

charipg SSCrazy Eights Points: 9888 More actions · Answer 6

thanks and how can i create model ,tempdb and resource dbs ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

tempdb is automatically recreated.

Model, you can restore from backup. Alternatively you can copy the mdf and ldf into the appropriate directory

Resource, you need to make sure you have those files available from backup.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

charipg SSCrazy Eights Points: 9888 More actions · Answer 8

charipg

SSCrazy Eights

Points: 9888

March 16, 2012 at 1:12 pm

#1460724

thanks....now everything is clear...

Chris Yates SSC Journeyman Points: 75 More actions · Answer 9

Agree with everything that has been said.......gives a whole new meaning to "You are only as good as your "last" backup" 😀

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

CYates (3/16/2012)
Agree with everything that has been said.......gives a whole new meaning to "You are only as good as your "last" backup" 😀

Backups are worthless,

Restores are priceless.