Post reply

Recovery Advisor won't open or start for specific database

  • July 1, 2014 at 10:46 pm

    #308689

    Greetings -

    Today we were trying to use restore wizard (recovery advisor) to restore a database which is over 80 GB, but the wizard won't load or start. However the wizard dialog box opens without any problems with all other databases stored in the instance. Is there any problem or reason to why the restore wizard won't come up?

    This is SQL 2012 enterprise version we are running.

    Thanks in advance for your help..

  • July 2, 2014 at 9:19 am

    #1726543

    Update: it turned out that we had our transaction log job was starting every single minute, even though the scheduler is set to every 10 min, causing the history tables in msdn to have thousands and thousands of records. Clearing the history records and correcting the job did the work.

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

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