Difference between revisions of "SQL server backup"
Ccunha64415 (talk | contribs) |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <span data-link_translate_ro_title="Backup SQL Server" data-link_translate_ro_url="Backup SQL Server"></span>[[:ro:Backup SQL Server]][[ro:Backup SQL Server]] | ||
| + | <span data-link_translate_ru_title="Резервное копирование SQL Server" data-link_translate_ru_url="Резервное копирование SQL Server"></span>[[:ru:Резервное копирование SQL Server]][[ru:Резервное копирование SQL Server]] | ||
| + | <span data-link_translate_pl_title="Kopia zapasowa serwera SQL" data-link_translate_pl_url="Kopia zapasowa serwera SQL"></span>[[:pl:Kopia zapasowa serwera SQL]][[pl:Kopia zapasowa serwera SQL]] | ||
| + | <span data-link_translate_ja_title="SQL Serverバックアップ" data-link_translate_ja_url="SQL Serverバックアップ"></span>[[:ja:SQL Serverバックアップ]][[ja:SQL Serverバックアップ]] | ||
| + | <span data-link_translate_zh_title="SQL服务器备份" data-link_translate_zh_url="SQL服务器备份"></span>[[:zh:SQL服务器备份]][[zh:SQL服务器备份]] | ||
| + | <span data-link_translate_de_title="SQL-Server-Sicherung" data-link_translate_de_url="SQL-Server-Sicherung"></span>[[:de:SQL-Server-Sicherung]][[de:SQL-Server-Sicherung]] | ||
| + | <span data-link_translate_nl_title="SQL Server Back-up" data-link_translate_nl_url="SQL Server Back-up"></span>[[:nl:SQL Server Back-up]][[nl:SQL Server Back-up]] | ||
<span data-link_translate_it_title="Backup di SQL Server" data-link_translate_it_url="Backup di SQL Server"></span>[[:it:Backup di SQL Server]][[it:Backup di SQL Server]] | <span data-link_translate_it_title="Backup di SQL Server" data-link_translate_it_url="Backup di SQL Server"></span>[[:it:Backup di SQL Server]][[it:Backup di SQL Server]] | ||
<span data-link_translate_pt_title="Cópia de Segurança do SQL Server" data-link_translate_pt_url="Cópia de Segurança do SQL Server"></span>[[:pt:Cópia de Segurança do SQL Server]][[pt:Cópia de Segurança do SQL Server]] | <span data-link_translate_pt_title="Cópia de Segurança do SQL Server" data-link_translate_pt_url="Cópia de Segurança do SQL Server"></span>[[:pt:Cópia de Segurança do SQL Server]][[pt:Cópia de Segurança do SQL Server]] | ||
| Line 14: | Line 21: | ||
|image_alt=Wiki Logo | |image_alt=Wiki Logo | ||
}} | }} | ||
| − | |||
| − | |||
==Introduction== <!--T:1--> | ==Introduction== <!--T:1--> | ||
| Line 85: | Line 90: | ||
<!-- Placez ci-dessous la ou les catégories auxquelles se rapporte votre article. Ex: [[Category:Contribute]] [[Category:Linux]] --> | <!-- Placez ci-dessous la ou les catégories auxquelles se rapporte votre article. Ex: [[Category:Contribute]] [[Category:Linux]] --> | ||
| − | [[Category:Acronis | + | [[Category:Backup Acronis]] |
Latest revision as of 16:14, 23 January 2022
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