Post reply

Verify Multiple Backups Using Single Statement

  • October 25, 2007 at 6:26 am

    #180612

    Hi all,

    I have taken more than one database backups and i have an idea that we can verify single backup using "restore verifyonly from disk=' '" statement.

    Now my question is Could we verify all(More than one backup) backups with single statement?

    Any suggestion would be helpful to me:-)

    Thanks in advance,

    Bagath.

  • October 25, 2007 at 11:12 pm

    #745572

    Bagath (10/25/2007)

    Hi all,

    I have taken more than one database backups and i have an idea that we can verify single backup using "restore verifyonly from disk=' '" statement.

    Now my question is Could we verify all(More than one backup) backups with single statement?

    Any suggestion would be helpful to me:-)

    Thanks in advance,

    Bagath.

    Deal all,

    Finay i got the solution as below...

    ========================================

    declare @stmt varchar (255)

    declare @loc varchar(100)

    select @loc= cast (physical_device_name as varchar(200)) from backupmediafamily

    set @stmt = 'restore verifyonly from disk = '''+ @loc +''''

    exec (@stmt)

    ========================================

    Thanks to all.....

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

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