to read the TRN file names from a folder

  • Hello every one.

    we are in the process of restoring a database with 1 full backup and about 38 trans log backups. the problem is we have about 180

    databases so the process can be very tedious. My manager want's me to come up with either a t-script or batch script so it can just

    read the names of the trn files from a folder and plug it in the restore script , he doesnt want me to do it one by one as for 180 databases will take alot of time. I know how to back up and restore but have no idea how to go about make it read it from a file.

    i hope every 1 out there will understand by problem . the trn files are sitting in a folder , from there they will be restored.

    Thanx

    bobby

  • Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please, direct replies to:

    http://www.sqlservercentral.com/Forums/Topic568224-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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