Yes, any Core based licenses under SPLA including SQL Server have Disaster Recovery rights. Please see below the extract from SPUR regarding the main limitations of DR rights:
Permitted Periods of Use
The disaster recovery server can run only during the following exception periods:
- For brief periods of disaster recovery testing within one week every 90 days.
- During a disaster, while the production server being recovered is down.
- Around the time of a disaster, for a brief period, to assist in the transfer between the primary production server and the disaster recovery server.
Conditions on Use
In order to use the software under disaster recovery rights, service provider must comply with the following terms:
- The disaster recovery server must not be running at any other times except as above.
- The disaster recovery server may not be in the same cluster as the production server.
- Use of the software on the disaster recovery server must comply with the license terms for the software.
- Once the disaster recovery process is complete and the production server is recovered, the disaster recovery server must not be running at any other times except those times allowed here.