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.
SQL Server – Using NAS Device as Backup Target
backupsql server
Related Question
- Sql-server – SQL Server – backup / restore schema only
- Sql-server – File locations for Full Text Catalogs using SQL Server 2005 on VMware
- SQL Server Backup to NAS – Step-by-Step Guide
- SQL Server – Deploying SQL Server Backup Maintenance Plan in Multi-Tenant Environment
- sql-server – How to Backup to NAS Using SQLCMD
- SQL Server – Assigning Domain User to Run MSSQLSERVER Service
Best Answer
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.