{"id":404,"date":"2016-10-26T17:42:12","date_gmt":"2016-10-26T14:12:12","guid":{"rendered":"http:\/\/shayanit.ir\/?p=404"},"modified":"2017-07-01T06:13:36","modified_gmt":"2017-07-01T01:43:36","slug":"%d8%a8%da%a9%d8%a7%d9%be-%da%af%db%8c%d8%b1%db%8c-%d8%a7%d8%b2-%d8%af%db%8c%d8%aa%d8%a7%d8%a8%db%8c%d8%b3-%d8%af%d8%b1-sql-server-2008","status":"publish","type":"post","link":"http:\/\/shayanit.ir\/?p=404","title":{"rendered":"\u0628\u06a9\u0627\u067e \u06af\u06cc\u0631\u06cc \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 SQL Server 2008"},"content":{"rendered":"<div class=\"col-xs-12 col-sm-12 col-md-12 padding-10\"><\/div>\n<div class=\"col-xs-12 col-sm-12 col-md-12 padding-10\">\n<blockquote>\n<p dir=\"rtl\"><img decoding=\"async\" src=\"http:\/\/www.fastteamit.com\/img_article\/MS-SQL-2008.jpg\" \/><\/p>\n<p dir=\"rtl\"><strong>\u0628\u06a9\u0627\u067e \u06af\u06cc\u0631\u06cc \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 SQL Server 2008:<\/strong><\/p>\n<\/blockquote>\n<p dir=\"rtl\" style=\"padding-right: 30px;\">\u06f1-\u00a0\u00a0\u00a0 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 Microsoft SQL Server \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/p>\n<blockquote>\n<p dir=\"rtl\">\u06f2-\u00a0\u00a0\u00a0 \u0646\u0627\u0645 user \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u0631\u0645\u0632 \u0645\u0631\u0628\u0648\u0637 \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p dir=\"rtl\">\u06f3-\u00a0\u00a0\u00a0 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 tasks \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p dir=\"rtl\"><strong>Select database &gt;&gt; Right-click &gt;&gt; Tasks &gt;&gt; Back Up<\/strong><\/p>\n<p dir=\"rtl\"><strong><br \/>\n<\/strong><\/p>\n<p dir=\"rtl\"><strong>\u00a0<\/strong><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(9).jpg\" alt=\"\" width=\"443\" height=\"215\" \/><\/p>\n<p dir=\"rtl\"><strong><br \/>\n\u0628\u0639\u062f \u0627\u0632 \u0627\u0646\u062a\u062e\u0627\u0628<\/strong><strong>Backup<\/strong><strong>\u0635\u0641\u062d\u0647 \u06cc \u0632\u06cc\u0631 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f:<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(8).jpg\" alt=\"\" width=\"697\" height=\"625\" \/><\/p>\n<p dir=\"rtl\">\u06f4-\u00a0\u00a0\u00a0 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0627\u0644\u0627\u060c \u0642\u0633\u0645\u062a Backup type \u0631\u0627 Full \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p dir=\"rtl\">\u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0628\u06a9\u0627\u067e \u062f\u0631 \u0642\u0633\u0645\u062a Backup to: Disk \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p dir=\"rtl\">\u06f5-\u00a0\u00a0\u00a0 \u062d\u0627\u0644 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Add \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f. \u0645\u0633\u06cc\u0631 \u0648 \u0646\u0627\u0645\u06cc \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0641\u0627\u06cc\u0644 \u0628\u06a9\u0627\u067e \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(7).jpg\" alt=\"\" width=\"432\" height=\"252\" \/><\/p>\n<p dir=\"rtl\">\u06f6-\u00a0\u00a0\u00a0\u00a0 \u0641\u0627\u06cc\u0644 \u0628\u06a9\u0627\u067e \u0631\u0627 \u0628\u0627 \u067e\u0633\u0648\u0646\u062f .bak \u0630\u062e\u06cc\u0631\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(6).jpg\" alt=\"\" width=\"424\" height=\"599\" \/><\/p>\n<p dir=\"rtl\">\u062f\u0642\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u067e\u0648\u0634\u0647 \u06cc \u0628\u06a9\u0627\u067e \u060c \u0632\u06cc\u0631 \u0634\u0627\u062e\u0647 \u06cc MSSQL \u0628\u0627\u0634\u062f.<\/p>\n<p dir=\"rtl\">\u06f7-\u00a0\u00a0\u00a0 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Ok \u06a9\u0644\u06cc\u06a9 \u0646\u0645\u0627\u06cc\u06cc\u062f. \u062f\u0631\u0635\u0648\u0631\u062a\u06cc\u06a9\u0647 \u0628\u06a9\u0627\u067e \u06af\u06cc\u0631\u06cc \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f \u0635\u0641\u062d\u0647 \u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(5).jpg\" alt=\"\" width=\"607\" height=\"118\" \/><\/p>\n<p>\u0686\u06af\u0648\u0646\u06af\u06cc \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0628\u06a9\u0627\u067e \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631<strong>SQL Server 2008<\/strong><strong>:<\/strong><\/p>\n<p dir=\"rtl\">\u06f1-\u00a0\u00a0\u00a0 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 Microsoft SQL Server \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0631\u0628\u0648\u0637\u0647 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f.<\/p>\n<p dir=\"rtl\">\u06f2-\u00a0\u00a0\u00a0 \u0628\u0631 \u0631\u0648\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 tasks \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p dir=\"rtl\"><strong>Select the database &gt;&gt; Right-click &gt;&gt; Tasks &gt;&gt; Restore &gt;&gt; Database<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(4).jpg\" alt=\"\" width=\"599\" height=\"209\" \/><\/p>\n<p dir=\"rtl\">\u06f3-\u00a0\u00a0\u00a0 \u0645\u0637\u0627\u0628\u0642 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u201cFrom device\u201d \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(3).jpg\" alt=\"\" width=\"699\" height=\"626\" \/><\/p>\n<p dir=\"rtl\">\u06f4-\u00a0\u00a0\u00a0 \u062d\u0627\u0644 \u0645\u0637\u0627\u0628\u0642 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631\u060c \u0642\u0633\u0645\u062a Backup media \u0631\u0627 File \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u062f\u06a9\u0645\u0647 Add \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(2).jpg\" alt=\"\" width=\"486\" height=\"347\" \/><\/p>\n<p dir=\"rtl\">\u06f5-\u00a0\u00a0\u00a0 \u0641\u0627\u06cc\u0644 \u0628\u06a9\u0627\u067e \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u062c\u0647\u062a \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0645\u0648\u062f\u0647 \u0648 \u062f\u06a9\u0645\u0647 Ok \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hub.iranserver.com\/pic\/websitepanel\/SQL-Server-2008-Backup%20(1).jpg\" alt=\"\" width=\"422\" height=\"599\" \/><\/p>\n<p dir=\"rtl\">\u062f\u0631 \u0635\u0648\u0631\u062a\u06cc\u06a9\u0647 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0628\u06a9\u0627\u067e \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f\u060c \u067e\u06cc\u063a\u0627\u0645\u00a0\u00a0 \u201cThe restoration of database \u201cyourdatabasename\u201d completed successfully.\u201d \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<\/blockquote>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0628\u06a9\u0627\u067e \u06af\u06cc\u0631\u06cc \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 SQL Server 2008: \u06f1-\u00a0\u00a0\u00a0 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 Microsoft SQL Server \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f. \u06f2-\u00a0\u00a0\u00a0 \u0646\u0627\u0645 user&nbsp;[&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":409,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-404","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-11","post-item clearfix"],"_links":{"self":[{"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/posts\/404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/shayanit.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=404"}],"version-history":[{"count":4,"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/posts\/404\/revisions"}],"predecessor-version":[{"id":410,"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/posts\/404\/revisions\/410"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/shayanit.ir\/index.php?rest_route=\/wp\/v2\/media\/409"}],"wp:attachment":[{"href":"http:\/\/shayanit.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/shayanit.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=404"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/shayanit.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}