Home Forums SQL Server 2005 Backups Script to restore red gate backups automatically from a folder. RE: Script to restore red gate backups automatically from a folder.

  • September 20, 2016 at 8:31 am

    #1901890

    How to include the "stats and Replace" options?

    EXECUTE master..sqlbackup '-SQL

    "RESTORE DATABASE [ABCD] FROM DISK = ''D:\backup\file.sqb''

    WITH RECOVERY

    , MOVE ''abc_1'' TO ''F:\MSSQL\Data\as.mdf''

    , MOVE ''abc_1_log'' TO ''G:\MSSQL\Logs\2_log.ldf''"'

    --, Stats = 10

    --, Replace'

    Thanks.