How to Backup SQL Active/Passive cluster Database to File Share

  • Hi

    We have 2 node Active/Passive SQL serer cluster with 2 databases, due to the backup disk capacity limitations we are planned to backup databases to the File Share location (\\192.168.0.x\Backup). When we trying to connect File Share to the WSFC there is no option to add file share it is showing only the availble RDM disks which are assign to SQL role.

    Appreciate it if someone can give an sugesstion for this.

    Thanks

  • You can backup directly to the UNC path, you don't need to mount the file share to the cluster to backup to it.

     

    BACKUP DATABASE master TO DISK = '\\192.168.0.x\backup\master.bak'

     

    If you want to mount the file share as a drive letter "EG Drive Z", you would need to do something similar to

    https://www.mssqltips.com/sqlservertip/3499/make-network-path-visible-for-sql-server-backup-and-restore-in-ssms/

  • Hi

     

    Thank you so much for your reply. Yes, it is works for me.

    Thanks

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply