3 Replies Latest reply on Nov 17, 2015 7:51 PM by RichardLetts

    Installation of MS SQL 2014 Standard

    rmccullar

      I've been tasked with installing SolarWinds (NPM, IPAM, SAM, and STM). We will be using a physical server for the database, and a VM for the applications. My SQL knowledge is very limited.

       

      Per the SQL Server Configuration Best Practices document, I am wanting to install Microsoft SQL Server 2014 Standard using the "recommended data storage setting with three HDDs".

       

      This configuration uses C: for OS and SQL temp directory, D: for Orion data files (such as .MDF), and E: for Orion transaction logs (.LDF).

       

      However, I am unable determine where these drives are configured during the SQL Server installation process so that the three SQL pieces listed above are located accordingly.

       

      Per tech support, no document exists (not even for a plain-jane SQL installation) for this so I was advised to post my request on Thwack.

       

      I did search for sql install and sql configure on Thwack before posting but found nothing that addresses my need.

       

      Thanks,

      Rob

        • Re: Installation of MS SQL 2014 Standard
          RichardLetts

          a) Do the install

          b) shutdown everything

          c) move the files (something like)

           

          1. Get the logical name of the data and log files:

          USE master

          SELECT name, physical_name FROM sys.master_files WHERE database_id = DB_ID('SolarWindsOrion');

          this is what I get:

           

          namephysical_name
          SolarWindsOrionE:\MSSQL\DATA\SolarWindsOrion.mdf
          SolarWindsOrion_logF:\MSSQL\LOG\SolarWindsOrion_log.LDF
          SolarWindsOrion_FG1E:\MSSQL\DATA\SolarWindsOrion_FG1.mdf
          SolarWindsOrion_FG2E:\MSSQL\DATA\SolarWindsOrion_FG2.mdf
          SolarWindsOrion_FG3E:\MSSQL\DATA\SolarWindsOrion_FG3.mdf
          SolarWindsOrion_FG4E:\MSSQL\DATA\SolarWindsOrion_FG4.mdf

           

          2. Take the database you want to work with offline:

          ALTER DATABASE SolarWindsOrion SET offline

           

          3. Move one file at a time to the new location:

          ALTER DATABASE SolarWindsOrion MODIFY FILE ( NAME = 'SolarWindsOrion' , FILENAME = 'D:\Data\SolarWindsOrion.mdf')

          [edit and repeat as necessary]

           

          5. Put the database online :

          ALTER DATABASE SolarWindsOrionSET online GO