Skip to content

new-updated-linux.md

Latest commit

 

History

History
302 lines (165 loc) · 13.3 KB

new-updated-linux.md

File metadata and controls

302 lines (165 loc) · 13.3 KB
title Updated - SQL Server on Linux docs | Microsoft Docs
description Display snippets of updated content for recently changed in documentation, for Microsoft SQL Server on Linux.
manager craigg
author MightyPen
ms.author genemi
ms.topic article
ms.custom UpdArt.exe
ms.suite sql
ms.technology release-landing
ms.prod sql
ms.component linux
ms.date 04/28/2018

New and Recently Updated: SQL Server on Linux docs

Nearly every day Microsoft updates some of its existing articles on its Docs.Microsoft.com documentation website. This article displays excerpts from recently updated articles. Links to new articles might also be listed.

This article is generated by a program that is rerun periodically. Occasionally an excerpt can appear with imperfect formatting, or as markdown from the source article. Images are never displayed here.

Recent updates are reported for the following date range and subject:

  • Date range of updates:   2018-02-03   -to-   2018-04-28
  • Subject area:   Microsoft SQL Server on Linux.

 

New Articles Created Recently

The following links jump to new articles that have been added recently.

  1. Active Directory authentication for SQL Server on Linux
  2. Configure SQL Server Always On Availability Group on Windows and Linux (cross-platform)
  3. Operate Always On Availability Groups on Linux

 

Updated Articles with Excerpts

This section displays the excerpts of updates gathered from articles that have recently experienced a large update.

The excerpts displayed here appear separated from their proper semantic context. Also, sometimes an excerpt is separated from important markdown syntax that surrounds it in the actual article. Therefore these excerpts are for general guidance only. The excerpts only enable you to know whether your interests warrant taking the time to click and visit the actual article.

For these and other reasons, do not copy code from these excerpts, and do not take as exact truth any text excerpt. Instead, visit the actual article.

 

Compact List of Articles Updated Recently

This compact list provides links to all the updated articles that are listed in the Excerpts section.

  1. Configure repositories for installing and upgrading SQL Server on Linux
  2. Configure SQL Server on Linux with the mssql-conf tool
  3. Release notes for SQL Server 2017 on Linux

 

 

1.   Configure repositories for installing and upgrading SQL Server on Linux

Updated: 2018-04-25           (Next)

 

  • Print out the contents of the file.
   sudo cat /etc/yum.repos.d/mssql-server.repo
  • The name property is the configured repository. You can identify it with the table in the [Repositories] section of this article.

Remove old repository (RHEL)

If necessary, remove the old repository with the following command.

sudo rm -rf /etc/yum.repos.d/mssql-server.repo

This command assumes that the file identified in the previous section was named mssql-server.repo.

Configure new repository (RHEL)

Configure the new repository to use for SQL Server installations and upgrades. Use one of the following commands to configure the repository of your choice.

Repository Command
CU sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
GDR sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017-gdr.repo

Configure SLES repositories

Use the following steps to configure repositories on SLES.

Check for previously configured repositories (SLES)

First verify whether you have already registered a SQL Server repository.

  • Use zypper info to get information about any previously configured repository.
   sudo zypper info mssql-server
  • The Repository property is the configured repository. You can identify it with the table in the [Repositories] section of this article.

Remove old repository (SLES)

If necessary, remove the old repository. Use one of the following commands based on the type of previously configured repository.

Repository Command to remove
Preview sudo zypper removerepo 'packages-microsoft-com-mssql-server'

 

 

2.   Configure SQL Server on Linux with the mssql-conf tool

Updated: 2018-04-25           (Previous | Next)

 

Change the default master database file directory location

The filelocation.masterdatafile and filelocation.masterlogfile setting changes the location where the SQL Server engine looks for the master database files. By default, this location is /var/opt/mssql/data.

To change these settings, use the following steps:

  • Create the target directory for new error log files. The following example creates a new /tmp/masterdatabasedir directory:
   sudo mkdir /tmp/masterdatabasedir
  • Change the owner and group of the directory to the mssql user:
   sudo chown mssql /tmp/masterdatabasedir
   sudo chgrp mssql /tmp/masterdatabasedir
  • Use mssql-conf to change the default master database directory for the master data and log files with the set command:
   sudo /opt/mssql/bin/mssql-conf set filelocation.masterdatafile /tmp/masterdatabasedir/master.mdf
   sudo /opt/mssql/bin/mssql-conf set filelocation.masterlogfile /tmp/masterdatabasedir/mastlog.ldf
  • Stop the SQL Server service:
   sudo systemctl stop mssql-server
  • Move the master.mdf and masterlog.ldf:
   sudo mv /var/opt/mssql/data/master.mdf /tmp/masterdatabasedir/master.mdf
   sudo mv /var/opt/mssql/data/mastlog.ldf /tmp/masterdatabasedir/mastlog.ldf
  • Start the SQL Server service:
   sudo systemctl start mssql-server

Note

If SQL Server cannot find master.mdf and mastlog.ldf files in the specified directory, a templated copy of the system databases will be automatically created in the specified directory, and SQL Server will successfully start up. However, metadata such as user databases, server logins, server certificates, encryption keys, SQL agent jobs, or old SA login password will not be updated in the new master database. You will have to stop SQL Server and move your old master.mdf and mastlog.ldf to the new specified location and start SQL Server to continue using the existing metadata.

 

 

3.   Release notes for SQL Server 2017 on Linux

Updated: 2018-04-25           (Previous)

 

  • [Enable SQL Server Agent]

CU6 (April 2018)

This is the Cumulative Update 6 (CU6) release of SQL Server 2017. The SQL Server engine version for this release is 14.0.3025.34. For information about the fixes and improvements in this release, see https://support.microsoft.com/help/4101464.

Package details

For manual or offline package installations, you can download the RPM and Debian packages with the information in the following table:

Package Package version Downloads
Red Hat RPM package 14.0.3025.34-3 Engine RPM package
High Availability RPM package
Full-text Search RPM package
SSIS package
SLES RPM package 14.0.3025.34-3 mssql-server Engine RPM package
High Availability RPM package
Full-text Search RPM package
Ubuntu 16.04 Debian package 14.0.3025.34-3 Engine Debian package
High Availability Debian package
Full-text Search Debian package
SSIS package

Similar articles about new or updated articles

This section lists very similar articles for recently updated articles in other subject areas, within our public GitHub.com repository: MicrosoftDocs/sql-docs.

Subject areas that do have new or recently updated articles

Subject areas that do not have any new or recently updated articles