Post reply

Backup name, description, and exp date

  • July 23, 2002 at 11:11 am

    #79413

    I notice the other day when I was doing a restore headeronly (from one of my tape backups) that there is no backupname, backupdescription, or expiration_date in the data returned from the restore headeronly commnand.

    How do I give these areas names from the tape. Also, I want to be able to fill a tape to a certain amount, and then write over it. How would I accomplish this.

    thanks.

  • July 25, 2002 at 6:05 pm

    #433412

    First it depends on how you perform them. If the the maintainence wizard or thru EM there are options for that you can choose or fill in. if thru BACKUP DATABASE sql command then do

    BACKUP DATABASE dbName

    TO TAPE = 'tapedevice'

    WITH

    MEDIANAME = 'backupname',

    MEDIADESCRIPTION = 'backupdescription',

    EXPIREDATE = date

    plus any other options you need. For more help see BOL. Also above items can be set with variables.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply