Difference between revisions of "Create a dump with SQL Server"
⧼vector-jumptonavigation⧽
⧼vector-jumptosearch⧽
Ccunha64415 (talk | contribs) |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 18: | Line 18: | ||
<span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="ro"></span><span data-link_translate="pl"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --> | <span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="he"></span><span data-link_translate="ro"></span><span data-link_translate="ru"></span><span data-link_translate="pl"></span><span data-link_translate="ja"></span><span data-link_translate="ar"></span><span data-link_translate="zh"></span><span data-link_translate="ro"></span><span data-link_translate="pl"></span><span data-link_translate="de"></span><span data-link_translate="nl"></span><span data-link_translate="it"></span><span data-link_translate="pt"></span><span data-link_translate="es"></span><span data-link_translate="en"></span><!-- Début de l'article. Placez votre texte ci-après et n'hésitez pas à personnaliser les chapitres selon votre besoin --> | ||
| + | |||
| + | {{#seo: | ||
| + | |title=Create a dump with SQL Server | ||
| + | |titlemode=replace | ||
| + | |keywords=SQL Server | ||
| + | |description=How to create a dump of its SQL Server database? | ||
| + | |og:type=article | ||
| + | |og:image=https://en-wiki.ikoula.com/resources/assets/logo_ikwiki.png | ||
| + | |||
| + | }} | ||
| + | |||
| + | [[File:Sqlserver.png|300px|right|SQL server logo]] | ||
==Introduction == <!--T:1--> | ==Introduction == <!--T:1--> | ||
| − | How to create a dump of its SQL Server database | + | How to create a dump of its '''SQL Server''' database |
| + | |||
| + | ==What is a dump?== | ||
| + | Generally refers to a raw copy of data from one device to another; for example to perform a data backup, display them on a terminal, or persist the data of a RAM. It differs from backup, which refers to structured copies | ||
| − | == | + | ==Run on SQL Server == <!--T:2--> |
| − | In order to proceed, we will need to "SQL Server Managment Studio " in its most recent version : | + | In order to proceed, we will need to "''SQL Server'' Managment Studio " in its most recent version : |
If you do not have the program, you can retrieve it via the following link : https://msdn.microsoft.com/en-us/library/mt238290.aspx | If you do not have the program, you can retrieve it via the following link : https://msdn.microsoft.com/en-us/library/mt238290.aspx | ||
| Line 30: | Line 45: | ||
Launch the program, it will then ask you to log in : | Launch the program, it will then ask you to log in : | ||
| − | [[File: | + | [[File:Connect-sqlserver.jpg|center|SQL Server connect]] |
| Line 47: | Line 62: | ||
Once connected, locate your database in the left menu and then made a right click on it in order to obtain the following result : | Once connected, locate your database in the left menu and then made a right click on it in order to obtain the following result : | ||
| − | [[File: | + | [[File:Generate-script-1.jpg|center|Generate Script]] |
| Line 57: | Line 72: | ||
Make next twice until arrival to the next screen and click on "Advanced " : | Make next twice until arrival to the next screen and click on "Advanced " : | ||
| − | [[File: | + | [[File:Generate-script-4.jpg|center|1]] |
Then change the line "Types of data to script " for the benefit of the value "Schema and data " and then drag "OK ". | Then change the line "Types of data to script " for the benefit of the value "Schema and data " and then drag "OK ". | ||
| Line 67: | Line 82: | ||
Once operations are complete, your dump will be on your computer. | Once operations are complete, your dump will be on your computer. | ||
| − | |||
==Conclusion == <!--T:3--> | ==Conclusion == <!--T:3--> | ||
| Line 83: | Line 97: | ||
<!-- 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: | + | [[Category:Web Hosting]] [[Category:Linux]] [[Category:Plesk]] |
Latest revision as of 16:22, 23 January 2022
en:Create a dump with SQL Server
he:ליצור חור עם SQL Server
ro:Creaţi o groapa cu SQL Server
ru:Создание дампа с SQL Server
pl:Utworzyć automatyczna kopia zapasowa z programem SQL Server
ja:SQL Server のダンプを作成します。
ar:إنشاء ملف تفريغ باستخدام SQL Server
zh:与 SQL Server 创建转储
de:Erstellen Sie einen Dump mit SQL Server
nl:Een dump maken met SQL Server
it:Creare un dump con SQL Server
pt:Criar um despejo com SQL Server
es:Crear un volcado de SQL Server
fr:Créer un dump avec SQL Server
This article has been created by an automatic translation software. You can view the article source here.
Introduction
How to create a dump of its SQL Server database
What is a dump?
Generally refers to a raw copy of data from one device to another; for example to perform a data backup, display them on a terminal, or persist the data of a RAM. It differs from backup, which refers to structured copies
Run on SQL Server
In order to proceed, we will need to "SQL Server Managment Studio " in its most recent version :
If you do not have the program, you can retrieve it via the following link : https://msdn.microsoft.com/en-us/library/mt238290.aspx
Launch the program, it will then ask you to log in :
Server type : Database Engine
Server name : <Enter here the ip address of your performance or your field>
Authentication : SQL Server authentication
Login : <Votre utilisateur>
Password : <Votre mot de passe>
Once connected, locate your database in the left menu and then made a right click on it in order to obtain the following result :
Then click on generate script.
This will open a wizard .
Make next twice until arrival to the next screen and click on "Advanced " :
Then change the line "Types of data to script " for the benefit of the value "Schema and data " and then drag "OK ".
Also remember to fill in the name and location of your dump by clicking on "..." in the front of the field "File name ".
Made "next" until the "finish ".
Once operations are complete, your dump will be on your computer.
Conclusion
You have just made a backup in the text of your MSSQL database format.
This article seemed you to be useful ?
0
Enable comment auto-refresher