Post reply

command line restore

  • March 29, 2005 at 12:37 pm

    #88452

    I backup a varying number of transaction logs each day, all appended to the same file.  I would like to perform a command line restore, by just providing the filename and having all logs with that file be restored.  Is there any way to do this?

  • March 29, 2005 at 4:15 pm

    #549439

    As far as I know the only way you can do this is if you use dump devices.  Define the device using sp_addumpdevice then do your backups (full and t-log) to the device.  Then you can just do something like this:

    RESTORE

    DATABASE Testing

    FROM TestingDump

    WITH

    STOPAT = '2005-03-29 16:53:34.967'

    HTH

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • March 30, 2005 at 3:45 am

    #549498

    Any reason you're using file append for the transaction logs?

    I tend to use individual files (as they're easier to keep track of), and have a Perl script that'll check for updated full backup, differentials and transaction logs, and only apply the relevant files for restore.

    If you absolutely have to stay with single file, and lack of scripting tools, then perhaps dcpeterson has hit the nail on the head for you.

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

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