patternsqlMinor
Using NAS device as SQL server backup target
Viewed 0 times
targetsqldevicenasusingserverbackup
Problem
I have used NAS devices as backup targets for SQL server databases. I have used them as file shares which are mapped to servers holding databases. Thing is that our current NAS supports iSCSI protocol and was wondering if I can use NAS LUNs (mapped as drives) in the SQL server virtual servers and take advantage of the protocol? Anyone who has tried this before or know about some difficulties/deficiencies using this method. Thanks.
Solution
Drive mapped iSCSI targets work perfectly for SQL Server backup destinations.
Map the iSCSI target into your VM as a drive, assign a drive letter inside the VM, and just do normal backups as you would to any other target.
I use that exact process for my clustered SQL Servers.
Map the iSCSI target into your VM as a drive, assign a drive letter inside the VM, and just do normal backups as you would to any other target.
I use that exact process for my clustered SQL Servers.
Context
StackExchange Database Administrators Q#162477, answer score: 8
Revisions (0)
No revisions yet.