{"id":3395,"date":"2023-12-19T23:02:07","date_gmt":"2024-01-24T23:52:53","guid":{"rendered":""},"modified":"2025-02-02T00:46:20","modified_gmt":"2025-02-01T23:46:20","slug":"instala-o-e-configura-o-do-microsoft-sql-server-no-linux-criar-banco-de-dados-abrir-portas-e-configurar-backups","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/instala-o-e-configura-o-do-microsoft-sql-server-no-linux-criar-banco-de-dados-abrir-portas-e-configurar-backups\/","title":{"rendered":"Instala\u00e7\u00e3o e configura\u00e7\u00e3o do Microsoft SQL Server no Linux: Criar banco de dados, abrir portas e configurar backups"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\u00a0<\/h1>\n

Introdu\u00e7\u00e3o<\/h2>\n

O Microsoft SQL Server \u00e9 um poderoso sistema de gerenciamento de banco de dados relacional (RDBMS) tradicionalmente associado ao Windows. No entanto, a Microsoft expandiu seu suporte para o Linux, permitindo que os usu\u00e1rios executem o SQL Server em v\u00e1rias plataformas. Este guia ir\u00e1 orient\u00e1-lo atrav\u00e9s do processo de instala\u00e7\u00e3o do Microsoft SQL Server no Linux, cria\u00e7\u00e3o de um banco de dados, abertura de portas para conex\u00f5es remotas, configura\u00e7\u00e3o de backups e cria\u00e7\u00e3o de scripts para automa\u00e7\u00e3o.<\/p>\n

Passo 1: Instalar o Microsoft SQL Server no Linux<\/h2>\n

Para instalar o Microsoft SQL Server em um sistema Linux, siga estas etapas:<\/p>\n

    \n
  1. Atualize o sistema:<\/strong>\n
    sudo apt-get update<\/code><\/pre>\n<\/li>\n
  2. Instale o pacote do SQL Server:<\/strong>\n
    sudo apt-get install -y mssql-server<\/code><\/pre>\n<\/li>\n
  3. Execute a configura\u00e7\u00e3o:<\/strong>\n
    sudo \/opt\/mssql\/bin\/mssql-conf setup<\/code><\/pre>\n
    Durante a configura\u00e7\u00e3o, voc\u00ea ser\u00e1 solicitado a aceitar os termos de licen\u00e7a e definir a senha do SA (Administrador do Sistema).<\/p>\n<\/li>\n
  4. Verifique a instala\u00e7\u00e3o:<\/strong>\n
    systemctl status mssql-server<\/code><\/pre>\n
    Este comando exibe o status do servi\u00e7o do SQL Server. Certifique-se de que ele est\u00e1 em execu\u00e7\u00e3o.<\/p>\n<\/li>\n<\/ol>\n
    Passo 2: Criar um banco de dados<\/h2>\n
    Ap\u00f3s a instala\u00e7\u00e3o do SQL Server, voc\u00ea pode criar um banco de dados seguindo estas etapas:<\/p>\n
      \n
    1. Conecte-se ao SQL Server:<\/strong>\n
      sqlcmd -S localhost -U SA -P 'SuaSenha'<\/code><\/pre>\n<\/li>\n
    2. Crie um novo banco de dados:<\/strong>\n
      CREATE DATABASE TestDB;<\/code><\/pre>\n<\/li>\n
    3. Verifique a cria\u00e7\u00e3o do banco de dados:<\/strong>\n
      SELECT Name FROM sys.databases;<\/code><\/pre>\n<\/li>\n<\/ol>\n
      Passo 3: Abrir portas para conex\u00f5es remotas<\/h2>\n
      Para permitir conex\u00f5es remotas \u00e0 sua inst\u00e2ncia do SQL Server, voc\u00ea precisa abrir a porta apropriada (padr\u00e3o \u00e9 1433) no firewall do Linux.<\/p>\n
        \n
      1. Abra a porta:<\/strong>\n
        sudo ufw allow 1433\/tcp<\/code><\/pre>\n<\/li>\n
      2. Habilite o firewall:<\/strong>\n
        sudo ufw enable<\/code><\/pre>\n<\/li>\n
      3. Verifique o status do firewall:<\/strong>\n
        sudo ufw status<\/code><\/pre>\n<\/li>\n<\/ol>\n
        Passo 4: Configurar backups<\/h2>\n
        Backups regulares s\u00e3o essenciais para a prote\u00e7\u00e3o de dados. Aqui est\u00e1 como configurar backups autom\u00e1ticos:<\/p>\n
          \n
        1. Crie um diret\u00f3rio para backups:<\/strong>\n
          sudo mkdir \/var\/opt\/mssql\/backup<\/code><\/pre>\n<\/li>\n
        2. Defina as permiss\u00f5es:<\/strong>\n
          sudo chown mssql:mssql \/var\/opt\/mssql\/backup<\/code><\/pre>\n<\/li>\n
        3. Crie um script de backup:<\/strong>\n
          sudo nano \/usr\/local\/bin\/backup_db.sh<\/code><\/pre>\n
          Adicione o seguinte conte\u00fado ao script:<\/p>\n
          #!\/bin\/bash\r\nsqlcmd -S localhost -U SA -P 'SuaSenha' -Q \"BACKUP DATABASE TestDB TO DISK = '\/var\/opt\/mssql\/backup\/TestDB.bak'\"\r\n            <\/code><\/pre>\n<\/li>\n
        4. Torne o script execut\u00e1vel:<\/strong>\n
          sudo chmod +x \/usr\/local\/bin\/backup_db.sh<\/code><\/pre>\n<\/li>\n
        5. Agende o backup com cron:<\/strong>\n
          crontab -e<\/code><\/pre>\n
          Adicione a seguinte linha para agendar um backup di\u00e1rio \u00e0s 2 da manh\u00e3:<\/p>\n
          0 2 * * * \/usr\/local\/bin\/backup_db.sh<\/code><\/pre>\n<\/li>\n<\/ol>\n
          Passo 5: Automatizar tarefas com scripts<\/h2>\n
          Voc\u00ea pode automatizar v\u00e1rias tarefas usando scripts. Por exemplo, para automatizar tarefas de manuten\u00e7\u00e3o do banco de dados, voc\u00ea pode criar um script e agend\u00e1-lo com o cron.<\/p>\n
            \n
          1. Crie um script de manuten\u00e7\u00e3o:<\/strong>\n
            sudo nano \/usr\/local\/bin\/db_maintenance.sh<\/code><\/pre>\n
            Adicione o seguinte conte\u00fado ao script:<\/p>\n
            #!\/bin\/bash\r\nsqlcmd -S localhost -U SA -P 'SuaSenha' -Q \"DBCC CHECKDB('TestDB') WITH NO_INFOMSGS, ALL_ERRORMSGS\"\r\n            <\/code><\/pre>\n<\/li>\n
          2. Torne o script execut\u00e1vel:<\/strong>\n
            sudo chmod +x \/usr\/local\/bin\/db_maintenance.sh<\/code><\/pre>\n<\/li>\n
          3. Agende o script com cron:<\/strong>\n
            crontab -e<\/code><\/pre>\n
            Adicione a seguinte linha para agendar a execu\u00e7\u00e3o semanal do script:<\/p>\n
            0 3 * * 1 \/usr\/local\/bin\/db_maintenance.sh<\/code><\/pre>\n<\/li>\n<\/ol>\n
            Conclus\u00e3o<\/h2>\n
            Seguindo este guia, voc\u00ea instalou com sucesso o Microsoft SQL Server em um sistema Linux, criou um banco de dados, abriu portas para conex\u00f5es remotas, configurou backups autom\u00e1ticos e criou scripts para automa\u00e7\u00e3o. Essas etapas ajudar\u00e3o voc\u00ea a gerenciar sua inst\u00e2ncia do SQL Server de forma eficiente e garantir a seguran\u00e7a e acessibilidade dos seus dados.<\/p>\n
            Para configura\u00e7\u00f5es e otimiza\u00e7\u00f5es mais avan\u00e7adas, consulte a documenta\u00e7\u00e3o oficial do Microsoft SQL Server no Linux<\/a>.<\/p>\n
            \n
            Author:<\/strong> \u0141ukasz Bodziony<\/p>\n
            Website:<\/strong> Windows VPS<\/a><\/p>\n
            \u0141ukasz Bodziony is the CEO and founder of NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance Windows VPS<\/strong> and Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n
            His expertise covers a wide range of technologies, including Microsoft Azure<\/strong>, Proxmox VE<\/strong>, Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n
            Beyond running his hosting business, \u0141ukasz also provides professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n
            If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
            \u00a0 \u00a0 Introdu\u00e7\u00e3o O Microsoft SQL Server \u00e9 um poderoso sistema de gerenciamento de banco de dados relacional (RDBMS) tradicionalmente associado ao Windows. No entanto, a Microsoft expandiu\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-3395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/3395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=3395"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/3395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=3395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=3395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=3395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}