Microsoft SQL Server on Linux OS
Cohesity provides backup and recovery solutions for Microsoft SQL Server databases running on the Linux Operating System.
Requirements
| Operating System | Database | Notes |
|---|---|---|
|
Linux OS RHEL 8 and higher versions This is an Early Access feature. Contact Cohesity Support to enable the feature. |
Microsoft SQL Server 2019 |
|
Considerations
-
Cross-platform database restores between Windows and Linux are currently not supported.
-
For VDI-based backups to work, Microsoft requires the backup application account (Cohesity Agent’s service account) and the Microsoft SQL Server service account to be added to each other’s primary groups using the usermod command.
For example:
sudo usermod -a -G mssql cohesityagent
sudo usermod -a -G cohesityagent mssql
where, mssql is the user account of the mssql-server service and cohesityagent is the user account of the Cohesity Agent service.
Following this, the Microsoft SQL Server and the Cohesity Agent services must be restarted for the changes to take effect.
The usermod -a -G command may not work for domain accounts.
-
Currently, only password-based SQL Server authentication is supported and Active Directory-based authentication is not supported for Linux.
For supported features of SQL Server 2019 on Linux, see Editions and supported features of SQL Server 2019 on Linux.
Register SQL Server on Linux OS
-
In DataProtect as a Service, select Sources.
-
Click +Register Source > Microsoft SQL > Start Registration.
-
In the Register Microsoft SQL Server page, select the SaaS Connection and click Continue.
-
In the Hostname or IP Address field, enter the IP address of the server, FQDN of the server, or VIP of the SQL FCI. Cohesity recommends you to provide the FQDN of the server.
-
Select the Server Type as Linux.
-
Provide the username and password for the Database Authentication.
-
Click Complete.
