Veeam Backup & Replication Config Backup Hatası

İlgili Makaleler

Object Storage Migration – Ceph Rados GW to Minio S3 Bucket Migration – Rclone

12 Eylül 2022

Docker Üzerinde Zabbix Monitoring Sunucusu Çalıştırma

7 Nisan 2021

Debian üzerinde Seafile Private Cloud Kurulumu

29 Kasım 2020

How to manually backup a SQL DB

Purpose

This article documents how to manually backup a Microsoft SQL Database.

Solution

Using SQL Server Management Studio

1. Open Microsoft SQL Server Management Studio (May need to be installed separately)
2. Connect to the “ServerName\Instance” of the server that has the DB you want backed up.
3. Expand the Databases tab to get to the DB you want to back up.
4. Right click the desired DB –> Tasks –> Back Up…
5. Set “Backup Type” to “Full”
6. Go through the rest of the General and Options tab information to set the options to what you want.
7. Click OK to start the Backup process.

Using sqlcmd

If SQL Management Studio is not installed, the Veeam database can be collected using SQLCMD:

1. Check the name of the SQL instance and Veeam database in windows registry
   • HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlDatabaseName
   • HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlInstanceName
   • HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlServerName
2. Open an Administrative Command Prompt and connect to SQL instance:
   SQLCMD -S (SqlServerName)\SqlInstanceName
   Note: In case you have SQL server authentication enabled you may define username using ‘-U’ parameter.
3. Backup the Veeam database:
   BACKUP DATABASE SqlDatabaseName TO DISK = ‘C:\VeeamDB.bak’ GO

2. Change local languages at OS – level on Veeam server to English (it requires a server restart, so make sure that there are no jobs running);

It’s possible to perform with Control Panel > Region:

– Format > English (United States);

– Current language for non-Unicode programs > English (United States);

– Control Panel->Region and Language->Administrative->Copy Settings->check “welcome screen and system accounts”

Restart the OS;

3. Open SQL Management Studio, connect to the instance where Veeam database is located.
4. Then, select SQL instance – right-click – go to properties. After that, find and open Connections tab and enable following options under ‘Default connections options’ section:

ANSI_NULLS

QUOTED_IDENTIFIER

CONCAT_NULL_YIELDS_NULL

ANSI_WARNINGS

ANSI_PADDING

Additionaly, please verify that the same options are enabled in Veeam database. For that:

1. Right-click on Veeam database – Properties
2. Options tab – Miscellaneous
3. Change the same settings to true

ANSI_NULLS

QUOTED_IDENTIFIER

CONCAT_NULL_YIELDS_NULL

ANSI_WARNINGS

ANSI_PADDING

4. Actions below should change SQL Collation to required “Latin1_General_CI_AS”

Open PowerShell console as administrator and run following commands:

Get-Service -DisplayName “Veeam*” | stop-service ( make sure no jobs are running please as rebooting our main server will break them )

Stop-Service -DisplayName ‘SQL Server (VEEAMSQL2016)’ -f

cd ‘C:\Program Files\Microsoft SQL Server\MSSQL13.VEEAMSQL2016\MSSQL\Binn’

.\sqlservr.exe -m -T4022 -T3659 -s”VEEAMSQL2016″ -q”Latin1_General_CI_AS”

Start-Service -DisplayName ‘SQL Server (VEEAMSQL2016)’

Get-Service -DisplayName “Veeam*” | start-service