Rebuilding System Databases on a cluster

I am having trouble rebuilding the SQL 2005 system databases on my cluster.

The Cluster hardware failed completely and I am recovering from scratch (but only 1 node at this time)

The Win2K3 OS is recovered and communicating with the domain.

Cluster services have started and the quorum is online.

The clustered SQL instance is offline because there is no master.mdf present.

I run the setup command as per BOL:

start /wait setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user> AGTPASSWORD=<DomainUserPassword>

The Summary.log reports the following:

Machine: CLUSTER1

Product: Microsoft SQL Server 2005

Product Version: 9.00.1399.06

Install: Successful

Log File: C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0001_CLUSTERSVR1_SQL.log

--

Setup succeeded with the installation, inspect the log file completely for status on all the components.

However the Microsoft SQL Server\MSSQL.1\MSSQL\DATA directory is empty.There are no system databases.

Without a rebuilt Master I cannot bring the clustered SQL instance online to then restore my database backups.

Any ideas?

D.

I believe (need to refresh some dusty brain-cells) that the system databases would need to be built on the shared volume(s) that are part of the clustered instance Resource Group. Otherwise, when the instance failed over, it would not be able to find its system databases.

So, Have you looked there to see if the system databases were rebuilt?

What is the response when you attempt to bring the SQL group online in the cluster admin?

What is in the SQL log and system Event log?

|||

The system databases are stored on one the shared drives, and this is where I am looking for my rebuilt databases to be placed.

If I search the whole system it does not find a Master.mdf file

The SQL group will not come online because it cannot find the Master.mdf (Application Event Log).

|||

If the SQL Group will not come online, how can you check the shared disk for the master database?

Master.mdf should also be on the shared drive which is part of the SQL group.

|||

Sorry for the confusiuon (and the delay in replying)

The shared disk resource comes online so I am able to browse it.

The SQL Server resource within the group will not come online because Master.mdf is not there.

|||

Please post the results of CLUSTER GROUP/PROP

so that I can see how things are layed out.

|||Did you find a fix for this as i'm having exactly the same problem and its driving me crazy.

Thanks

Liam

Rebuilding System Databases on a cluster

I am having trouble rebuilding the SQL 2005 system databases on my cluster.

The Cluster hardware failed completely and I am recovering from scratch (but only 1 node at this time)

The Win2K3 OS is recovered and communicating with the domain.

Cluster services have started and the quorum is online.

The clustered SQL instance is offline because there is no master.mdf present.

I run the setup command as per BOL:

start /wait setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user> AGTPASSWORD=<DomainUserPassword>

The Summary.log reports the following:

Machine: CLUSTER1

Product: Microsoft SQL Server 2005

Product Version: 9.00.1399.06

Install: Successful

Log File: C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0001_CLUSTERSVR1_SQL.log

--

Setup succeeded with the installation, inspect the log file completely for status on all the components.

However the Microsoft SQL Server\MSSQL.1\MSSQL\DATA directory is empty.There are no system databases.

Without a rebuilt Master I cannot bring the clustered SQL instance online to then restore my database backups.

Any ideas?

D.

I believe (need to refresh some dusty brain-cells) that the system databases would need to be built on the shared volume(s) that are part of the clustered instance Resource Group. Otherwise, when the instance failed over, it would not be able to find its system databases.

So, Have you looked there to see if the system databases were rebuilt?

What is the response when you attempt to bring the SQL group online in the cluster admin?

What is in the SQL log and system Event log?

|||

The system databases are stored on one the shared drives, and this is where I am looking for my rebuilt databases to be placed.

If I search the whole system it does not find a Master.mdf file

The SQL group will not come online because it cannot find the Master.mdf (Application Event Log).

|||

If the SQL Group will not come online, how can you check the shared disk for the master database?

Master.mdf should also be on the shared drive which is part of the SQL group.

|||

Sorry for the confusiuon (and the delay in replying)

The shared disk resource comes online so I am able to browse it.

The SQL Server resource within the group will not come online because Master.mdf is not there.

|||

Please post the results of CLUSTER GROUP/PROP

so that I can see how things are layed out.

|||Did you find a fix for this as i'm having exactly the same problem and its driving me crazy.

Thanks

Liamsql

Rebuilding System Databases on a cluster

I am having trouble rebuilding the SQL 2005 system databases on my cluster.

The Cluster hardware failed completely and I am recovering from scratch (but only 1 node at this time)

The Win2K3 OS is recovered and communicating with the domain.

Cluster services have started and the quorum is online.

The clustered SQL instance is offline because there is no master.mdf present.

I run the setup command as per BOL:

start /wait setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user> AGTPASSWORD=<DomainUserPassword>

The Summary.log reports the following:

Machine: CLUSTER1

Product: Microsoft SQL Server 2005

Product Version: 9.00.1399.06

Install: Successful

Log File: C:\Program Files\Microsoft SQL Server\Setup Bootstrap\LOG\Files\SQLSetup0001_CLUSTERSVR1_SQL.log

--

Setup succeeded with the installation, inspect the log file completely for status on all the components.

However the Microsoft SQL Server\MSSQL.1\MSSQL\DATA directory is empty.There are no system databases.

Without a rebuilt Master I cannot bring the clustered SQL instance online to then restore my database backups.

Any ideas?

D.

I believe (need to refresh some dusty brain-cells) that the system databases would need to be built on the shared volume(s) that are part of the clustered instance Resource Group. Otherwise, when the instance failed over, it would not be able to find its system databases.

So, Have you looked there to see if the system databases were rebuilt?

What is the response when you attempt to bring the SQL group online in the cluster admin?

What is in the SQL log and system Event log?

|||

The system databases are stored on one the shared drives, and this is where I am looking for my rebuilt databases to be placed.

If I search the whole system it does not find a Master.mdf file

The SQL group will not come online because it cannot find the Master.mdf (Application Event Log).

|||

If the SQL Group will not come online, how can you check the shared disk for the master database?

Master.mdf should also be on the shared drive which is part of the SQL group.

|||

Sorry for the confusiuon (and the delay in replying)

The shared disk resource comes online so I am able to browse it.

The SQL Server resource within the group will not come online because Master.mdf is not there.

|||

Please post the results of CLUSTER GROUP/PROP

so that I can see how things are layed out.

|||Did you find a fix for this as i'm having exactly the same problem and its driving me crazy.

Thanks

Liam

Re-boot is OK

Hi,
Rebooting is not a permanent solution.
Poor coding techniques & H/W resources not being planned
well for a SQL Box and Insufficient Hardware. Start
working on...
1. Application Tuning .
2. SQL Server Tuning ( not needed in most cases)
3. hardware Tuning
There is a good book from Microsoft press titled " SQL
Server 2000 Performance Tuning Tech Reference" by Whalen.
Also refer to Refer www.sql-server-performance.com . They
have loads of stuff on performance tuning.
HTH
Regards
THIRUMAL REDDY MARAM
Sys Admin / SQL DBA

quote:

---

>--Original Message--
>Does anyone know ehrn my SQL server is slow then I re-
>boot it. Onces I re-boot it, the SQL server performance
>become OK(normal). Does anyone know what is the problem
>and how to solve it.
>.
>

---

Hi,
During a problem situation do,
1. Use performance monitor to check the hardware usage,
1. CPU Usage
2. Memory Usage
3. Disk I/o
2. From query analyzer use sp_who to verify any blocked process.
3. Execute a select statment in sysprocess table to identify the
process/user using the resource
select substring(loginame,1,20) as login,cpu ,physical_io ,
memusage from sysprocesses
identify the user and execute a dbcc inputbuffer(spid) to check the
backend procedure / SQL he is executing.
Thanks
Hari
MCDBA
"Thirumal" <anonymous@.discussions.microsoft.com> wrote in message
news:115301c3df4b$ab6a0860$a601280a@.phx.gbl...[QUOTE]
> Hi,
> Rebooting is not a permanent solution.
> Poor coding techniques & H/W resources not being planned
> well for a SQL Box and Insufficient Hardware. Start
> working on...
> 1. Application Tuning .
> 2. SQL Server Tuning ( not needed in most cases)
> 3. hardware Tuning
> There is a good book from Microsoft press titled " SQL
> Server 2000 Performance Tuning Tech Reference" by Whalen.
> Also refer to Refer www.sql-server-performance.com . They
> have loads of stuff on performance tuning.
> HTH
> --
> Regards
> THIRUMAL REDDY MARAM
> Sys Admin / SQL DBA

Real experiences with 64 bit SQL Server

I am about to buy some database hardware, and am considering buying a
dual 64-bit opteron server. In the past, we have run been running the
32-bit version of SQL Server 2000.

Has anybody tried the new 64-bit version of Sql Server 2000? Can we
assume that something that works in the 32-bit world will work in the
64 bit, or are we going to spend time debugging Microsoft code? Also,
which flavor of 64-bit windows operating system did you use?

Any experiences you want to share are much appreciated...
-Cheers,
RichardFirst, we don't support the AMD Opteron processor, yet. I believe that we
might with a future service pack. The following site,
http://www.microsoft.com/sql/64bit/...info/sysreq.asp, says we only
support the Itanium 2 processor.

Once past that, please have a look at the following two KBs for information
regarding 64-bit Tools and DTS support:

http://support.microsoft.com/?kbid=813953
http://support.microsoft.com/?kbid=810927

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.

"Richard" <rvlasimsky@.voneconsulting.com> wrote in message
news:d72c60b6.0408260924.6270e6ac@.posting.google.c om...
>I am about to buy some database hardware, and am considering buying a
> dual 64-bit opteron server. In the past, we have run been running the
> 32-bit version of SQL Server 2000.
> Has anybody tried the new 64-bit version of Sql Server 2000? Can we
> assume that something that works in the 32-bit world will work in the
> 64 bit, or are we going to spend time debugging Microsoft code? Also,
> which flavor of 64-bit windows operating system did you use?
> Any experiences you want to share are much appreciated...
> -Cheers,
> Richard|||In article <d72c60b6.0408260924.6270e6ac@.posting.google.com>,
rvlasimsky@.voneconsulting.com says...
> I am about to buy some database hardware, and am considering buying a
> dual 64-bit opteron server. In the past, we have run been running the
> 32-bit version of SQL Server 2000.
> Has anybody tried the new 64-bit version of Sql Server 2000? Can we
> assume that something that works in the 32-bit world will work in the
> 64 bit, or are we going to spend time debugging Microsoft code? Also,
> which flavor of 64-bit windows operating system did you use?
> Any experiences you want to share are much appreciated...

Richard - I appreciate your desire to move into the future, but lets
face a simple truth: Tried and proven are always more stable.

If you want to run a low end server then purchase a Dual Xeon system
based on the ASUS PC-DL Deluxe motherboard. This board supports up to
4GB of RAM, has two RAID (SATA) Controllers, Standard IDE, and 1GB LAN.
When it comes to a low-end server, something that is not based on a Quad
board, the Dual Xeon PC-DL is a screamer. I've built more than a dozen
of these for test labs and two for production environments. If you don't
want to go to the expense of SCSI, consider the Promise SX6000 6 drive
IDE RAID Controller with 128MB of cache. With the SX6000 you can have a
single RAID-5 array (6 x 250GB) IDE base, a MIRROR set (2 x 250GB) on
the Intel SATA RAID Controller) and a MIRROR set (2 x 40GB) on the
standard IDE channel for the OS.

With this system you can run the OS on a 40GB partition, the Database
Log files on the a 250GB mirror and the database data files on a 1.2TB
RAID 5 array. Oh, forgot the most important part - the SX6000, while
being just ATA133 allows for "hot-swapping" IDE drives.

In a chenbro case, with dual 550W PSU's and a DVD+RW drive, and Windows
2003 Standard Server (5 CAL) I can get these for about $4,400 USD.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)