Home Forums SQL Server 2016 SQL Server 2016 - Administration Need to put large database into norecovery state RE: Need to put large database into norecovery state

  • December 27, 2017 at 3:16 pm

    #1973640

    WebTechie - Wednesday, December 27, 2017 1:43 PM

    That was my thought also, but I wanted to put the question out just in case.

    I had norecovery for full backup restore as well as the log files during my last restore attempt.  This time, I will use query analyzer instead of the gui to make sure it is "norecovery".

    It  just that restore took 3 hours.

    Thanks.

    Unfortunately you will have to start over.
    In my opinion, learn to do backups and restores using t-sql instead of the GUI. There seems to be too many issues, display problems and such using the GUI which is further complicated by the display issues being different on different versions of SSMS. There is no question on what's being executed when using t-sql. The GUI can become a bit of a black box.

    Sue