• No. Backup to a file. Ignore devices.

    BACKUP DATABASE DBName
    TO DISK =  <file name here>

    The file name can be a variable, so you can build up the string with the  date.

    If you create backups to disk, it'll create exactly the type of backup you specify. Want a differential, specify WITH DIFFERENTIAL

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass