Post reply

Need T-SQL command to render NOINIT log backup set

  • July 16, 2008 at 6:05 am

    #70463

    How can I see the full compliment of transaction log backups in a single .DMP file?

    FYI, I'm running a nightly FULL BACKUP on Database_A then I run Hourly Log backups on Database_A via this command:

    BACKUP LOG Database_A TO DISK='C:\MyDisk\MyDBLogBackup.dmp' INIT

    --and subsequently run this NOINIT command throughout the day:

    BACKUP LOG Database_A TO DISK='C:\MyDisk\MyDBLogBackup.dmp' NOINIT

    After this Backup process runs multiple times I then run the following command:

    RESTORE FILELISTONLY FROM DISK='C:\MyDisk\MyDBLogBackup.dmp'

    and I see the .mdf and .ldf

    What is the command to render the list of contiguous log backup files appended to the set?

    BT

  • July 16, 2008 at 6:27 am

    #843718

    RESTORE [font="Comic Sans MS"]HEADERONLY[/font] FROM DISK='C:\MyDisk\MyDBLogBackup.dmp'

  • July 16, 2008 at 6:46 am

    #843728

    thx Ian -- exactly what I was looking for..

    BT

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

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