Cluster Management - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Cluster Management

Author

Topic

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-07-29 : 01:53:04

Hi

We have two clustering nodes and each consisting atleast 40 databases.

What are the steps / procedure to maintain and if the cluster databases crashed out and thereafter restore them.

Thanks for you replies in Advance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-29 : 23:19:54

Same procedure as on stand along server.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-07-30 : 02:13:51

can You please elaborate with some details as I dont have any such stuff.

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-30 : 23:04:16

How do you perform those tasks on standalong servers? Do same on clustered ones.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-04 : 19:28:59

I Couldn't find any relevant information as how I can do. But Any clues will surely gives where to start.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-04 : 19:36:03

pdset, you need to provide us with more information in order for us to properly help you. Please describe exactly what you mean.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-04 : 20:23:22

Thanks TKizer.

We have 2 cluster Nodes each consists of around 40 Databases and were doing fine.

We have jobs assigned to run the backups and other relevant jobs running absolutely fine.

I was custodian of these databases and asked to deliver the PLAN FOR DISASTER RECOVERY in the event if the Crash occurs, however, I dont have any other source but the backups were running and transaction Logs for every 15 minutes duration.

My Question, How I need to restore and recover from the crash occured and is the source what I have indicated with existing backups and using Point In Time utilizing Logs to recover and restore;

OR

Is there any method I need to pick it. Since It is clustered environment, I just want to know what is the best availability method for recover and restore for a crash occured.

Thanks in Advance Tara.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-04 : 20:31:17

Restoring a database does not change on a clustered instance or on a standalone instance. You still use the RESTORE command.

How you recover in your situation depends on what the issue is. There are hundreds of things that can happen, we can't cover each of these. So if you have a specific question such as a specific failure, then feel free to ask.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-04 : 21:25:02

Thanks Tara for being very specific.

However, the circumstances leads me otherday, I was crashed out all the databases in one of the cluster nodes.

In this case, How I need to recover and restore.

further, in specific nature...............

What are the possibilities that I can come across apart from crashed out server node, which I am not aware of it.

Ex: restore and recover process for the database from another thread of another clustered node.

Thanks in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-04 : 21:37:30

It depends on what you mean by "crash". It could mean lots of things. Each might have a different resolution.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-04 : 21:40:20

Based on the scenario that all databases were crashed out in one cluster node and other cluster node is working fine, then how to recover and restore.

Thanks Tara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-04 : 21:52:48

You need to define "crashed out" for us. Explain exactly what scenario you are referring to. Are we talking about BSOD, corrupt databases, SQL Server is unable to start, ...?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-04 : 23:43:00

Other day, I have one database was not starting up when tried to startup is not doing so, I just recovered that database but eventually, another database(s) were subsequently crashed.

This is going on for couple of times over the days.

Secondly, the whole cluster node databases were crashed out but could able to recover and restore from the snapshot folder but I am not convinced that it might again do the fail.

May I know now, based on the last two instances narrated is there any methodology that I can restore, recover them, and moreover, what are the PREVENTIVE steps I need to take in the Clustering Nodes.

Thanks Tara

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-04 : 23:52:33

Did you find out why those incidents happened? Again, they are not cluster specific issue, can happen on any sql instance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-05 : 00:03:44

You need to describe your issue more clearly. We still don't have enough information for us to help.

What status were the databases in? What did DBCC CHECKDB show? What was in the SQL Server Error Log? What was in the Application Log and System Log in Event Viewer?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-05 : 00:14:16

What status were the databases in?

active mode

What did DBCC CHECKDB show?
I could not perform since database is unavailable

[b]What was in the SQL Server Error Log?

Error log shows database is crashed out due to files unable to roll forward at the time of restoring and recovery.

[b]what was in the Application Log and System Log in Event Viewer?

System log has no information but Application log says the event was unsuccessful as the operation failed to succeed.

Thanks Tara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-05 : 00:16:39

Please show us the exact errors from the error log.

How could a database be active if you can't access it? What error did you get upon accessing it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-06 : 00:24:21

The database was active prior to restoring.

thereafter,The database not coming up while trying after being restored, incidentally, there is no significant message in error log as it says database failed to be in active mode.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-06 : 01:17:50

But what error message did you get when you tried to access it?

We really can't help with the limited information you have given us.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-06 : 23:10:04

How did you restore db? Did you get any error during restore? Is backup file good? You can check that with 'restore verifyonly'.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2008-08-10 : 23:04:44

Thanks to Tara & Rmiao

I have good backup from the snapshot folder and could able to restore it and it worked. Prior to that I have made database in restricted mode and it got restored and recovered.

My Other question, if I dont possess the good backup how I can restore the database?

Thanks once again.

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources