SQL Server Performance Forum – Threads Archive

Media and Device- General Concepts

can anyone word out difference between a Device and a media , with the following T-SQL statements . sp_helpdevice @devname = ‘Device1’ Restore labelonly from device1 THnx in advance Rajiv
SQL-DBA

Backups created in SQL 2K are stored using the Microsoft Tape Format (MSTF). MSTF is not specific to tapes; it can also be used for backing up to either disks or named pipes. Each time a SQL Server backup is performed, it forms a backup set. This backup set is stored in an MSTF unit called a media. BOL refers sp_helpdevice is used for backward compatibility with earlier versions of SQL Server that used the term device for a database file.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

tnx satya, does it means both device and media are same?? or media is a logical concept only? if i am right, a device can contain only one media. then whts media set ? m with lots of questions <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> . Rajiv SQL-DBA

The backup media is the actual physical storage used by the backup device to store the backup. Backup media can be either disk or tape. A media set can contain one or more backup sets and describes all of the media used by those backup sets, regardless of the number of media or backup devices involved. A media family describes all the media used by a single backup device for a single backup set. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>