Post reply

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

  • August 16, 2023 at 8:36 am

    #4262457

    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

  • August 16, 2023 at 9:09 am

    #4262465

    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/

  • August 16, 2023 at 10:51 am

    #4262526

    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