December 2013
Intermediate to advanced
1872 pages
153h 31m
English
A backup device is used to provide a storage destination for the database backups created with SQL Server. Backups can be written to logical or physical devices. A logical device is essentially an alias to the physical device and makes it easier to refer to the device when performing database backups. The physical backup devices that SQL Server can write to include files on local disks, tape, and network shares.