Post reply

Back up File Analsys

  • July 29, 2010 at 6:57 am

    #225530

    i have a back up file with contain more than of backup and i want to know the number of the file of each backup for example i have the log back up but i dont know what to write on the file atttrib as there is on the same file also a full backup

    could any one help me how to now the contained of the back up file?

  • July 29, 2010 at 9:55 am

    #1199902

    Try Restore Headeronly.

    RESTORE HEADERONLY FROM <backup device>

    Greg

  • July 29, 2010 at 11:54 am

    #1199970

    thnx

  • July 29, 2010 at 12:54 pm

    #1200005

    Note that I wouldn't recommend this. I'd move each backup to a new file. If you have any issue with this file, and you could over time, you lose lots of backups, not one.

  • July 29, 2010 at 6:46 pm

    #1200090

    can i delete one of the backups from the file ?

  • July 30, 2010 at 8:06 am

    #1200349

    I don't think you can. You can set a retention period, but I believe that reuses space, similar to overwriting something on a tape. However it doesn't free up space.

    You can always restore each file to a new database, then run a backup of that db to a new file.

    I wouldn't worry about removing backups now. I might make a second copy of that file, but then start backing up each time to a new file.

Viewing 6 posts - 1 through 5 (of 5 total)

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