Sqlserver 2000 Installation Steps

Posted: January 4, 2008 in Sqlserver

    ÿ
    Establish whether this request truly needs a dedicated server, or if it can just reside on one of the shared servers. If a dedicated server is required, continue.

    ÿ Review DBA policies with the person making the request.

      ÿ Database Support – General.doc
      ÿ DBA Team SQL Server Support.doc

    ÿ Ensure licenses are in place. Establish that the project has purchased the appropriate licenses for the edition and number of users for the database. Clear this with Asset Management (TBD).

    ÿ The requestor must supply a server. Assist them in determining adequate resources—memory, CPU, and disk. Advise them to only install SQL Server, no other applications.

    ÿ Install SQL Server software. If this is a remote installation, work with Siemens to copy the software CDs to the server.

    ÿ During Installation, when you select the type of Installation, Change the default drive values for the data files, which should be other than the “Bin” Folder, which is always in “c:” drive.

          ÿ C:\Program Files\Microsoft SQL Server\MSSQL\Bin
          ÿ D:\Program Files\Microsoft SQL Server\MSSQL\Data

    ÿ Licensing Per Seat should be “100
    ÿ Best Practices:

      ÿ For all servers:

        ÿ Immediately patch the server to the latest SQL Server patch.
        ÿ Add “Domain\SQL Admins” to “System Administrators”
        Create a login “
        Domain\SQL Admins” or Whatever login you use
        ÿ In the SQL Enterprise Manager, Right Click on the Server and go to Properties
        ÿ In Properties tab, Set Autostart “SQL Server Agent”, “SQL Server” and “MSDTC”
        ÿ In Memory tab, Under “Dynamically configure SQL Server Memory”, check and see to that the “Maximum(MB)” should be less than the total Physical Memory of the System.

        ÿ Under Security tab, Set “Start up Service account” should be, “This account” “Domain Name\Username (“Domain\sqlexec”)

        ÿ Under Security tab, Set “Audit Level” to “All”
        ÿ Under “Database Settings” Setup default drive values for data and transaction log files.

          ÿ D:\Program Files\Microsoft SQL Server\MSSQL\Data
          ÿ D:\Program Files\Microsoft SQL Server\MSSQL\Transaction Logs
          or
          (Incase of three drives)
          ÿ E:\Program Files\Microsoft SQL Server\MSSQL\Transaction Logs

        ÿ Now expand “Management” Folder, Right click on the “SQL Server Agent”,

          § In the “General” tab, “Mail Session”, select the existing Profile (you get the profile only if the Outlook express is already configured in the system)

          § To configure the OUTLOOK (Mail Host: EmailServerName, Mail Box: SQLExec)
          § In the “Advanced” tab, Under “Restart Services”,

            § Set “Auto restart SQL Server if it stops unexpectedly” on
            § Set “Auto restart SQL Server Agent if it stops unexpectedly” on

        ÿ Setup Three database maintenance plans

          ÿ Plan 1 – ALL USER DATABASES backup

            ÿ All user databases
            ÿ Reorganize data and index pages
            ÿ Remove unused space from database files
            ÿ Shrink database when it grows beyond 50 mb
            ÿ Check database integrity
            ÿ Include indexes
            ÿ Attempt to repair any minor problems
            ÿ Backup the database as part of the maintenance plan
            ÿ To Disk
            ÿ Use the default directory
            ÿ Remove files older than 4 weeks
            ÿ Backup file extension “BAK”
            ÿ Write report a text file in directory (default directory)
            ÿ Delete text report files older than 4 weeks

          ÿ Plan 2 – ALL SYSTEM DATABASE backup

            ÿ All system databases
            ÿ Reorganize data and index pages
            ÿ Remove unused space from database files
            ÿ Shrink database when it grows beyond 50 mb
            ÿ Check database integrity
            ÿ Include indexes
            ÿ Attempt to repair any minor problems
            ÿ Backup the database as part of the maintenance plan
            ÿ To Disk
            ÿ Use the default directory
            ÿ Remove files older than 4 weeks
            ÿ Backup file extension “BAK”
            ÿ Write report a text file in directory (default directory)
            ÿ Delete text report files older than 4 weeks

          ÿ Plan 3 – ALL TRANSACTION LOG BACKUP HAVING RECOVERY MODEL as Full

            ÿ Select databases having recovery model full
            ÿ Remove unused space from database files
            ÿ Shrink database when it grows beyond 50 mb
            ÿ Backup the transaction log of the database as part of the maintenance plan
            ÿ To Disk
            ÿ Use the default backup directory
            ÿ Remove files older than 4 weeks
            ÿ Backup file extension “TRN”
            ÿ Write report a text file in directory (default directory)
            ÿ Delete text report files older than 4 weeks

      ÿ For DBA Team owned servers:

        ÿ Remove “builtin\administrators” from “System Administrators”

          ÿ Expand the “Security” tab, click on the “Server Roles“ and then right click on the “sysadmin” -> select “Properties” and then check in the Role members, if “builtin\administrators” exist, if yes, then remove it.

        ÿ Set “Start and run SQL Server” to “na\sqlexec”.
        ÿ Setup alert system and configure the following alerts
        Optional: Include the ”TRN log Maintenance Plan” in the alert notification list.

            · Full MSDB Log – “Error – 9002”
            · Full TempDB – “Error – 9002”
            · “Server name” – Sev19 Errors
            · “Server name” – Full Log – “Error – 9002”
            · “Server name” – Insufficient Resources

        ÿ Right click on the “Operator” folder to create a New Operator

      ÿ For requestor owned servers:

        ÿ Set “Start and run SQL Server” to either system account, or account specified by requestor
        ÿ Set “Service startup account” to either system account, or account specified by requestor
        ÿ If the requestor wants alerts

          ÿ Get Outlook client installed
          ÿ (Details TBD)

Thanks
Md. S.Hassan
Sqlserver Database Administrator

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s