Rebuild database on SQL express 2008

[SQLScholar]

Hey all,

I have happily rebuilt the master database on SQL 2005\2008 std\ent.

However I am currently being flumuxed by 2008 express 64 bit.

It was installed as part of Sharepoint 2010. There is no media that this was installed from (on its own) but we obviously have the sharepoint media.

I cant find local setup bootstrap for it.

If i look at downloading media for it i get MSI files. If i unpack the 64bit version - no setup file. However if i unpack the x86 one - there is a setup file......

AGGHHHHHH how do i get this thing to rebuild. Tell you the truth this is a DR test - and i am planning to move this to std anyway. But i hate to be beaten

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mrdenny]

Why are you trying to rebuild master? In 14 years of doing this I think I've rebuild master once, maybe.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[SQLScholar]

Denny,

DR test. So files in use couldnt be backed up - so have to restore the master so that i can then start SQL then i can restore the master and all other DB`s.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mrdenny]

Why would you be backing up SQL databases by doing file level backups? Those aren't valid SQL Server backups.

Restoring master doesn't require rebuilding master first. Just start the SQL Server in single user mode from the command prompt and restore the master and msdb databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[SQLScholar]

Denny,

I am not backing up file level backups. I backup each database using the built in SQL backup tool.

As you cannot backup the mdf\ldf files (files in use) - then the master doesnt exist. Because the master doesnt exist you cannot start SQL server. So i do a rebuild so that i can then start sql in single user mode.

So - basically i follow the same steps i have always done. Seems to be the same as here:

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/rebuild-master-and-restore-system-databa

and as directed here (Restoring System Databases):

http://msdn.microsoft.com/en-us/library/ms190190.aspx

"Startup of an instance of SQL Server requires that the master database is accessible and at least partly usable"

As master is not accessible (so SQL wont start) - i would then follow the rebuild the master as per the instructions on here.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[SQLBill]

Who says you can't back up Master? You just have to do a Full Backup. Restoring Master is different than other databases:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/0bc9eed6-3441-4b75-af02-2944d321daf7.htm

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLScholar]

Sorry - i am not making myself clear. You cannot backup the mdf\LDF files (because they are in use), so i do a SQL backup of master.

Since - when you recover the entire server - the mdf files arent there for master (because they were in use and you couldnt back them up) it will not start. You cant recover the backup of master... because SQL wont start.

So you have to rebuild system databases to get to the point that you can restore the system databases.

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mrdenny]

How are you building your DR server? Are you taking tape backups of the OS of your production server and trying to restore them to your DR box? That's just going to be a nightmare.

Build the DR box from scratch, then install SQL Server on it. Then restore master, then msdb, then your user databases.

No rebuilds needed, no mess, no headaches.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[SQLScholar]

We have to do as you said in the first instance.....

There is other stuff on the said server that would make it more of a nightmare the other way round.

If it were just a SQL box i would agree with you......

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------