Difference between revisions of "SQL server backup"

From EN Ikoula wiki
⧼vector-jumptonavigation⧽ ⧼vector-jumptosearch⧽
Line 21: Line 21:
 
|image_alt=Wiki Logo
 
|image_alt=Wiki Logo
 
}}
 
}}
 
 
  
 
==Introduction== <!--T:1-->
 
==Introduction== <!--T:1-->

Revision as of 11:16, 28 September 2021

ro:Backup SQL Server ru:Резервное копирование SQL Server pl:Kopia zapasowa serwera SQL ja:SQL Serverバックアップ zh:SQL服务器备份 de:SQL-Server-Sicherung nl:SQL Server Back-up it:Backup di SQL Server pt:Cópia de Segurança do SQL Server es:Copia de seguridad de SQL Server fr:Backup serveur SQL
This article has been created by an automatic translation software. You can view the article source here.

Introduction

We will see how to install and use SQL protection with Acronis.

Course

First of all, it is advisable to have performed the Première connexion

On the https://acronis.ikoula.com, interface, once you have logged in, at the top right, click on "add" then in Applications, choose "Microsoft SQL Server".

File:SQL 1.JPG

Download the installation file and run it. You can leave the default options or change them as needed, then run the installation. There are few customizations.

File:SQL 2.JPG

You must now register the machine to your account.

File:SQL 3.JPG

Once done, add a plan to it, create one for SQL. You need to activate the "Microsoft SQL Server" option in the plan:

File:SQL 4.JPG

It will ask you for access to the machine (or domain):

File:SQL 5.JPG

Enter them and validate, validate the plan. Your server is now added and ready to be backed up. Launch your first backup when you can.

File:SQL 6.JPG

To restore, just go to the machine's backups, then click on restore, in the choices you will have "SQL Databases":

File:SQL 7.JPG

You will then see your backup of your SQL instance:

File:SQL 8.JPG

And there you can see your backed up databases:

File:SQL 9.JPG

Check one (or more) and choose the restore mode (Restore in a database or files). Here we take a database that we restore directly by overwriting the existing one:

File:SQL 10.JPG

We launch the restoration:

File:SQL 11.JPG

It should end up like this:

File:SQL 12.JPG

Conclusion

We now have a SQL backup with the possibility of restoring to a database or to a file.



Cet article vous a semblé utile ?

0



You are not allowed to post comments.