Home Forums SQL Server 2014 Administration - SQL Server 2014 Restore database without backup history in msdb RE: Restore database without backup history in msdb

  • July 29, 2014 at 5:57 pm

    #1733422

    Hema kumar-337490 (7/29/2014)

    Power shall is the best option to traverse the folder and generate the scripts.

    It's "PowerShell" and so far as it being the "best option", I'll say "It Depends". 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)