Restoring the SQL Server Configuration

  • JCALEX

    Valued Member

    Points: 54

    Hi SQL gurus, I had to rebuilt a Windows 2005 SQL Server Enterprise this company use to run ERP, very critical, the bare metal backup restore didn't work, so had to setup the OS from scratch, then updates, and the SQL Server.

    My question is if I can restore the configuration of the SQL server from the most recent full backup? I know the server had a configuration to enhance the performance of it.

    J.C. Alexandres
    IT Professional

  • Sue_H

    SSC Guru

    Points: 89699

    If you restore the system databases, master might have whatever configuration was changed. Might. It depends on whatever was changed.

    Sue

     

  • JCALEX

    Valued Member

    Points: 54

    Hi Sue;

    Thank you for your reply. I appreciate your suggestion, and I would probably have done that if I was at the stage of the server just being set, as it would represent not that much to lose if something goes south.

    I had to put the machine as it was in production yesterday, after some tweaking to the SQL logins, all has been working fine, now I will look at best practices for SQL Server optimization.

    Cheers!

     

    J.C. Alexandres
    IT Professional

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

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