• 1.as you mentioned 9 days lag why t is delay??

    is the rescoucre available frequently or not to monitor every day by day through which we can identify the issue

    if there is a delay of 9 days then what about the data stored at present

    2.is any users connected to the particular database ? ? or no work is performing in the database ??

    like steve said it is one option [ but it will take time and expensive, and we have to restore the backup as soon as possible most of them go for this option at last ] and another is in the case of urgent scenario

    option [1]

    1.first create a backup device and split the files as per ur backup size

    2. create a maintenance plan and add all the device backups and run the device backup maintenance plan

    3. after successful execution of backup manually copy the split backup files which u created in the source server in to the destination server in which u have to restore the database

    option [2]

    go for ftp or through unix box transfer the backup but both of them may cause break in network transfer mostly option[1] is better in my view

    Thanks
    Naga.Rohitkumar