Difference between revisions of "SQL server backup"
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".
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.
You must now register the machine to your account.
Once done, add a plan to it, create one for SQL. You need to activate the "Microsoft SQL Server" option in the plan:
It will ask you for access to the machine (or domain):
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.
To restore, just go to the machine's backups, then click on restore, in the choices you will have "SQL Databases":
You will then see your backup of your SQL instance:
And there you can see your backed up databases:
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:
We launch the restoration:
It should end up like this:
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 ?
Enable comment auto-refresher