Een dump maken met SQL Server: verschil tussen versies
(13 tussenliggende versies door een andere gebruiker niet weergegeven) | |||
Regel 1: | Regel 1: | ||
+ | <span data-link_translate_nl_title="Een dump maken met SQL Server" data-link_translate_nl_url="Een dump maken met SQL Server"></span>[[:nl:Een dump maken met SQL Server]][[nl:Een dump maken met SQL Server]] | ||
+ | <span data-link_translate_he_title="ליצור חור עם SQL Server" data-link_translate_he_url="%D7%9C%D7%99%D7%A6%D7%95%D7%A8+%D7%97%D7%95%D7%A8+%D7%A2%D7%9D+SQL+Server"></span>[[:he:ליצור חור עם SQL Server]][[he:ליצור חור עם SQL Server]] | ||
+ | <span data-link_translate_ro_title="Creaţi o groapa cu SQL Server" data-link_translate_ro_url="Crea%C5%A3i+o+groapa+cu+SQL+Server"></span>[[:ro:Creaţi o groapa cu SQL Server]][[ro:Creaţi o groapa cu SQL Server]] | ||
+ | <span data-link_translate_ru_title="Создание дампа с SQL Server" data-link_translate_ru_url="%D0%A1%D0%BE%D0%B7%D0%B4%D0%B0%D0%BD%D0%B8%D0%B5+%D0%B4%D0%B0%D0%BC%D0%BF%D0%B0+%D1%81+SQL+Server"></span>[[:ru:Создание дампа с SQL Server]][[ru:Создание дампа с SQL Server]] | ||
+ | <span data-link_translate_pl_title="Utworzyć automatyczna kopia zapasowa z programem SQL Server" data-link_translate_pl_url="Utworzy%C4%87+automatyczna+kopia+zapasowa+z+programem+SQL+Server"></span>[[:pl:Utworzyć automatyczna kopia zapasowa z programem SQL Server]][[pl:Utworzyć automatyczna kopia zapasowa z programem SQL Server]] | ||
+ | <span data-link_translate_ja_title="SQL Server のダンプを作成します。" data-link_translate_ja_url="SQL+Server+%E3%81%AE%E3%83%80%E3%83%B3%E3%83%97%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%BE%E3%81%99%E3%80%82"></span>[[:ja:SQL Server のダンプを作成します。]][[ja:SQL Server のダンプを作成します。]] | ||
+ | <span data-link_translate_ar_title="إنشاء ملف تفريغ باستخدام SQL Server" data-link_translate_ar_url="%D8%A5%D9%86%D8%B4%D8%A7%D8%A1+%D9%85%D9%84%D9%81+%D8%AA%D9%81%D8%B1%D9%8A%D8%BA+%D8%A8%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85+SQL+Server"></span>[[:ar:إنشاء ملف تفريغ باستخدام SQL Server]][[ar:إنشاء ملف تفريغ باستخدام SQL Server]] | ||
+ | <span data-link_translate_zh_title="与 SQL Server 创建转储" data-link_translate_zh_url="%E4%B8%8E+SQL+Server+%E5%88%9B%E5%BB%BA%E8%BD%AC%E5%82%A8"></span>[[:zh:与 SQL Server 创建转储]][[zh:与 SQL Server 创建转储]] | ||
+ | <span data-link_translate_de_title="Erstellen Sie einen Dump mit SQL Server" data-link_translate_de_url="Erstellen+Sie+einen+Dump+mit+SQL+Server"></span>[[:de:Erstellen Sie einen Dump mit SQL Server]][[de:Erstellen Sie einen Dump mit SQL Server]] | ||
+ | <span data-link_translate_it_title="Creare un dump con SQL Server" data-link_translate_it_url="Creare+un+dump+con+SQL+Server"></span>[[:it:Creare un dump con SQL Server]][[it:Creare un dump con SQL Server]] | ||
+ | <span data-link_translate_pt_title="Criar um despejo com SQL Server" data-link_translate_pt_url="Criar+um+despejo+com+SQL+Server"></span>[[:pt:Criar um despejo com SQL Server]][[pt:Criar um despejo com SQL Server]] | ||
+ | <span data-link_translate_es_title="Crear un volcado de SQL Server" data-link_translate_es_url="Crear+un+volcado+de+SQL+Server"></span>[[:es:Crear un volcado de SQL Server]][[es:Crear un volcado de SQL Server]] | ||
+ | <span data-link_translate_en_title="Create a dump with SQL Server" data-link_translate_en_url="Create+a+dump+with+SQL+Server"></span>[[:en:Create a dump with SQL Server]][[en:Create a dump with SQL Server]] | ||
<span data-link_translate_fr_title="Créer un dump avec SQL Server" data-link_translate_fr_url="Cr%C3%A9er_un_dump_avec_SQL_Server"></span>[[:fr:Créer un dump avec SQL Server]][[fr:Créer un dump avec SQL Server]] | <span data-link_translate_fr_title="Créer un dump avec SQL Server" data-link_translate_fr_url="Cr%C3%A9er_un_dump_avec_SQL_Server"></span>[[:fr:Créer un dump avec SQL Server]][[fr:Créer un dump avec SQL Server]] | ||
<br /> | <br /> | ||
Regel 5: | Regel 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=Een dump maken met SQL Server | ||
+ | |title_mode=append | ||
+ | |keywords=these,are,your,keywords | ||
+ | |description=Een dump maken met SQL Server | ||
+ | |image=Uploaded_file.png | ||
+ | |image_alt=Wiki Logo | ||
+ | }} | ||
==Introductie == <!--T:1--> | ==Introductie == <!--T:1--> |
Huidige versie van 18 okt 2021 om 11:35
nl:Een dump maken met 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
it:Creare un dump con SQL Server
pt:Criar um despejo com SQL Server
es:Crear un volcado de SQL Server
en:Create a dump with SQL Server
fr:Créer un dump avec SQL Server
Dit artikel is vertaald door middel van automatische vertalingssoftware. U kunt het artikel bron hier te bekijken.
Introductie
Hoe maak je een dump van de SQL Server-database
Plaats
Om door te gaan, zullen we moeten "SQL Server Management Studio " in de meest recente versie :
Als u het programma niet hebt, kunt u het via de volgende link ophalen : https://msdn.microsoft.com/en-us/library/mt238290.aspx
Start het programma, zal het vervolgens vragen u om in te loggen :
Servertype : Database Engine
Servernaam : <Voer hier het IP-adres van uw prestaties of uw veld>
Verificatie : SQL Server-verificatie
Login : <Votre utilisateur>
Wachtwoord : <Votre mot de passe>
Zodra verbonden, Zoek uw database in het linkermenu op en maakte vervolgens een klik met de rechtermuisknop op het om het volgende resultaat verkrijgen :
Klik op genereren script.
Hiermee opent u een wizard .
Maak twee keer tot de aankomst in het volgende scherm en klik op volgende "Geavanceerde " :
Verander dan de regel "Soorten gegevens aan script " ten behoeve van de waarde "Schema en de gegevens " en sleep vervolgens "OK ".
Ook niet vergeten in te vullen door te klikken op de naam en locatie voor uw dump "..." aan de voorkant van het veld "Bestandsnaam ".
Gemaakt "volgende " totdat de "voltooien ".
Als bewerkingen voltooid zijn, worden uw dump zal worden op uw computer.
Conclusie
U hebt zojuist een back-up in de tekst van uw MSSQL database-indeling.
Dit artikel leek u nuttig ?
Automatisch bijwerken van reacties inschakelen