SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Cluster file and backup disks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Charoniv
Starting Member

21 Posts

Posted - 08/20/2012 :  10:12:37  Show Profile  Reply with Quote
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

Thailand
60 Posts

Posted - 08/20/2012 :  12:29:14  Show Profile  Reply with Quote
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 - 08/20/2012 :  12:38:05  Show Profile  Reply with Quote
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

Thailand
60 Posts

Posted - 08/20/2012 :  12:40:07  Show Profile  Reply with Quote
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 - 08/20/2012 :  12:46:36  Show Profile  Reply with Quote
Thanks - that looks promising.
I'll look over it tomorrow.
Go to Top of Page

komkrit
Yak Posting Veteran

Thailand
60 Posts

Posted - 08/20/2012 :  20:23:42  Show Profile  Reply with Quote
Welcome

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Komkrit Yensirikul
Welcome for all questions. Let us know if our solution solved your problem.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000