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
 High Availability (2005)
 shared disk on cluster

Author  Topic 

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-04 : 20:32:54
Hi

Could anyone tell whether we can use a common shared disk for backup which can be used by the multiple instances that sit on a single node?

If yes, could please tell me the steps to setup a common backup disk for all the instances on a single cluster node?

Thank you,

Yours
SQL Buddy.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-06-05 : 14:36:46
you need to use different drives for different instances..

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-05 : 14:43:46

Hi Dinakar,

Thank you very much for your reply. I really appreciate it.

Yours
SQLBuddy
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-05 : 16:03:16
Well you can use a common location for your backups, but it'll need to be a remote server or perhaps even a NetApp.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-05 : 16:27:09
Hi Tara,

Thank you very much for your reply. I really appreciate your help.

If I want to take Native SQL backups of all instances that sit on a single node of a cluster onto the local drive (C:\) of that node and then periodically copy those backups onto a tape using Legato will there be any problems? Is this approach possible on a cluster? (Bcs our company is planning to implement this method)

Thanks,

Yours
SQLBuddy
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-06-05 : 17:22:24
I would highly not recommend putting anything on the C drive of a cluster.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-05 : 17:49:29
Hi Tara,

Thank you very much for your reply.

If it is possible I will try to avoid backing up to the local drive.

I really appreciate our help.

Yours
SQLBuddy
Go to Top of Page
   

- Advertisement -