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 2008 Forums
 High Availability (2008)
 Cluster file and backup disks

Author  Topic 

Charoniv
Starting Member

21 Posts

Posted - 2012-08-20 : 10:12:37
I've installed a cluster happily but now need to do something with files and backups. I think the requirements are the same - I want to take backups to disk and an external app will then copy those to tape (or whatever).
It means that the drive the backups are taken to will need to be accessible to the external app.
At the moment I have been given cluster disks but I think that means when the instance fails over the app will need to access a disk owned by a different server - similarly for anything deivering files.

An option would be to have another server for hosting the disks and the clustered instance access the shares for backup - is that the only way for doing this?

komkrit
Yak Posting Veteran

60 Posts

Posted - 2012-08-20 : 12:29:14
Dear Charoniv,

External App must be configured as cluster, and must be in SQL Cluster Group.
Whenever SQL failover to another node, then External App also failover together.
External App can access the same drive letter(cluster disk) and path.
Many tools such as monitoring tools, backup tools etc. configured like this.

Sound the UNC path hosting by another server better?


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Komkrit Yensirikul
Welcome for all questions. Let us know if our solution solved your problem.
Go to Top of Page

Charoniv
Starting Member

21 Posts

Posted - 2012-08-20 : 12:38:05
Can't configure the corporate file backup application as part of this cluster - nor the external processes that deliver files.
Go to Top of Page

komkrit
Yak Posting Veteran

60 Posts

Posted - 2012-08-20 : 12:40:07
Just another solution.

Create Shared Folder in Failover Cluster.
http://support.microsoft.com/kb/224967
http://technet.microsoft.com/en-us/library/cc732302.aspx
http://blogs.technet.com/b/askcore/archive/2010/08/19/working-with-file-shares-in-windows-server-2008-r2-failover-clusters.aspx
http://blogs.technet.com/b/askcore/archive/2009/01/09/file-share-scoping-in-windows-server-2008-failover-clusters.aspx


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Komkrit Yensirikul
Welcome for all questions. Let us know if our solution solved your problem.
Go to Top of Page

Charoniv
Starting Member

21 Posts

Posted - 2012-08-20 : 12:46:36
Thanks - that looks promising.
I'll look over it tomorrow.
Go to Top of Page

komkrit
Yak Posting Veteran

60 Posts

Posted - 2012-08-20 : 20:23:42
Welcome

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Komkrit Yensirikul
Welcome for all questions. Let us know if our solution solved your problem.
Go to Top of Page
   

- Advertisement -