Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond

Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
Tedmond
Hello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond

Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond

Restoring Database in a clustered environment

Can someone tell me how to make a backup in a sql clustered environment (MSSQL 2000) and how to restore that backup in clustered environment (MSSQL2005)? A step by step backup and restore procedure is appreciated.

regardless of if the server the db is on is clustered or not, the same principles apply

backup database dbname to file = 'c:\backup.bak'

same goes with the restore

here is an article that will help:

http://www.sqlteam.com/item.asp?ItemID=26689

|||

Hi Tim,

Yes the db is on clustered.. do i need to backup each db on each node? or just backup the active node's db?

|||

If the cluster is active/active (two instances, one on each node), and there are databases on the 2nd node that you want to backup, then you'll likely need to back that db up as well. Otherwise, you can backup the database on the active node.

The thing about a clustered environment is that it can host multiple instances. These instances are mutually exclusive from each other, so you can treat them like they are different server instances, even though at the time they may be on one node. So, just backup the databases as you normally would as if it was a nonclustered environment.

HTH,

Tim

|||

To take this to the simplest case:

Take a 2 node cluster with 1 instance, and 1 user database:

There is only one physical copy of that database. At any point in time, it may be mounted on node "A" or node "B".

The instance name is always the same, regardless of which physical machine hosts it.

So, to back up the database, you run a backup job on whichever node is currently hosting the instance.

Ideally, your backups go to media which is accessable from all cluster nodes, so that restores are clean as well. (another shared disk, or a network share if perf isn't as critical)

Restore is just the same: Go to the node which has your instance currently hosted (or move the instance to the node that you're currently on), and run restore.

For more complex configurations, just take the above and iterate for each instance.

There are 3rd party backup products which operate over the network, which will automatically go to the node currently hosting a database (via the instance's virtual hostname) and do the backup/restore on the appropriate machine.