{"id":347,"date":"2011-08-29T14:48:26","date_gmt":"2011-08-29T14:48:26","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=347"},"modified":"2011-08-29T14:48:26","modified_gmt":"2011-08-29T14:48:26","slug":"sauvegarde-automatique-sql-server-express-200x","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=347","title":{"rendered":"Sauvegarde automatique SQL Server Express 200X"},"content":{"rendered":"<p><strong><span style=\"text-decoration: underline;\">1- Commande T-SQL de Sauvegarde \u00e0 stocker dans un fichier sur C:backup.sql :<\/span><\/strong><\/p>\n<p>BACKUP DATABASE [<strong>DB_DATA<\/strong>] TO\u00a0 DISK = N&#8217;E:Srvper-Fullcrum<strong>dbdata<\/strong>&#8216; WITH NOFORMAT, <strong><span style=\"text-decoration: underline;\">INIT<\/span><\/strong>,\u00a0 NAME = N&#8217;LOGICAL_DATAS&#8217;, SKIP, NOREWIND, NOUNLOAD,\u00a0 STATS = 10<br \/>\nGO<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"text-decoration: underline;\">2- Commande en ligne via un save.bat :<\/span><\/strong><\/p>\n<p>C:Program FilesMicrosoft SQL Server90ToolsBinnSQLCMD.EXE -S<strong> SERVERINSTANCE SQL<\/strong> -E -i\u00a0 C:backupscript.sql<\/p>\n<p><strong><span style=\"text-decoration: underline;\">3- Planifier ine t\u00e2che :<\/span><\/strong><\/p>\n<p>Utilisez le planificateur de t\u00e2chesde windows\u00a0 pour\u00a0 lancer save.bat tous les soirs &#8230;<\/p>\n<p><em>N.B : L&#8217; option -E \u00e9vite de r\u00e9clamer le mot de passe SQL et l&#8217; option INIT \u00e9crase l&#8217; unit\u00e9 de sauvegarde tous les Soirs<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>http:\/\/www.microsoft.com\/download\/en\/details.aspx?displaylang=en&#038;id=15748<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1- Commande T-SQL de Sauvegarde \u00e0 stocker dans un fichier sur C:backup.sql : BACKUP DATABASE [DB_DATA] TO\u00a0 DISK = N&#8217;E:Srvper-Fullcrumdbdata&#8216; WITH NOFORMAT, INIT,\u00a0 NAME = N&#8217;LOGICAL_DATAS&#8217;, SKIP, NOREWIND, NOUNLOAD,\u00a0 STATS = 10 GO &nbsp;&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2845,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[28],"tags":[],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/347"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=347"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/347\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}