{"id":80,"date":"2018-05-30T06:45:02","date_gmt":"2018-05-30T06:45:02","guid":{"rendered":"http:\/\/dbtut.com\/?p=80"},"modified":"2020-10-22T12:45:46","modified_gmt":"2020-10-22T12:45:46","slug":"how-to-change-database-recovery-model-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/","title":{"rendered":"Change Database Recovery Model in SQL Server"},"content":{"rendered":"<p>In this article, we will change database recovery model in SQL Server via SSMS or script. Also I will share scripts to to find recovery model of all databases and change recovery model to simple for all databases in SQL Server at the end of the article.<\/p>\n<p><span lang=\"en-US\">If you want to learn below topics you should read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/26\/database-recovery-mode-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Database Recovery Mode in SQL Server<\/a>&#8220;<\/span><\/p>\n<ul>\n<li><span lang=\"tr\">What is recovery model?<\/span><\/li>\n<li>Database Recovery Models<\/li>\n<li>What is difference between simple and full recovery model?<\/li>\n<li>SQL Server Recovery Model Simple vs Full Performance<\/li>\n<li>Difference Between Full and Bulk Logged Recovery Model in SQL Server<\/li>\n<\/ul>\n<p><span lang=\"en-US\">We can change database recovery model through SSMS (SQL Server Managemet Studio) or TSQL script.<\/span><\/p>\n<h2>Change Database Recovery Model<\/h2>\n<p lang=\"en-US\">Right click on the database via SSMS and click Properties.<\/p>\n<p lang=\"en-US\">Go to the Options tab and select Full, Bulk-logged or Simple from Recovery Model and click OK.<\/p>\n<p lang=\"en-US\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/303.png\" width=\"697\" height=\"619\" \/><\/p>\n<p>In addition to SSMS, you can change database recovery mode by using the following script.<\/p>\n<p>You can set one of the following recovery models.<\/p>\n<ul>\n<li>FULL<\/li>\n<li>SIMPLE<\/li>\n<li>BULK_LOGGED<\/li>\n<\/ul>\n<pre class=\"\">USE [master]\r\nGO\r\nALTER DATABASE [your_db_name] SET RECOVERY your_recovery_model WITH NO_WAIT\r\nGO<\/pre>\n<h3>Change Database Recovery Mode to Simple<\/h3>\n<pre class=\"lang:default decode:true\">USE [master]\r\nGO\r\nALTER DATABASE [your_db_name] SET RECOVERY Simple WITH NO_WAIT\r\nGO<\/pre>\n<h3>Change Database Recovery Mode to Full<\/h3>\n<pre class=\"lang:default decode:true\">USE [master]\r\nGO\r\nALTER DATABASE [your_db_name] SET RECOVERY Full WITH NO_WAIT\r\nGO<\/pre>\n<h3>Change Database Recovery Mode to Bulk-Logged<\/h3>\n<pre class=\"lang:default decode:true\">USE [master]\r\nGO\r\nALTER DATABASE [your_db_name] SET RECOVERY Bulk_Logged WITH NO_WAIT\r\nGO<\/pre>\n<h2>Query to find recovery model of all databases in SQL Server<\/h2>\n<p>You may need to list all databases with recovery model information. Below script will help you.<\/p>\n<pre class=\"lang:default decode:true\">SELECT name, recovery_model_desc FROM sys.databases<\/pre>\n<p id=\"LQYtDXS\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"253\" class=\"size-full wp-image-17247 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/img_5f84101a27c1f.png\" alt=\"\" \/><\/p>\n<h2>Change Recovery Model to Simple for all Databases<\/h2>\n<p>You may need to change all databases recovery mode at once. But be careful when changing recovery model from full to simple. Because you can not backup your transaction log in simple recovery model.<\/p>\n<pre class=\"lang:default decode:true\">USE [master]\r\nGO\r\nDECLARE @dbname NVARCHAR(500)\r\nDECLARE mycursor CURSOR\r\nFOR\r\n--Exclude system databases with where clause.\r\nSELECT [name] FROM sys.databases where database_id&gt;4\r\nOPEN mycursor\r\n\r\nFETCH NEXT FROM mycursor INTO @dbname\r\nWHILE @@FETCH_STATUS=0\r\nBEGIN\r\n\r\nEXEC('ALTER DATABASE [' + @dbname + '] SET RECOVERY Simple')\r\n \r\nFETCH NEXT FROM mycursor INTO @dbname\r\nEND\r\n\r\nCLOSE mycursor\r\nDEALLOCATE mycursor\r\nGO<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_80\" class=\"pvc_stats all  \" data-element-id=\"80\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will change database recovery model in SQL Server via SSMS or script. Also I will share scripts to to find recovery model of all databases and change recovery model to simple for all databases in SQL Server at the end of the article. If you want to learn below topics you &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_80\" class=\"pvc_stats all  \" data-element-id=\"80\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":10968,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[5103,10178,10177,10176,2799,36,10175,10174,10170,5104,2798,5102,2790,2797,5105,2796,2792,5107,10171,10173,10172,5106],"class_list":["post-80","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-can-i-change-recovery-model-from-full-to-simple","tag-change-database-recovery-mode-to-bulk-logged","tag-change-database-recovery-mode-to-full","tag-change-database-recovery-mode-to-simple","tag-change-database-recovery-model","tag-change-recovery-model","tag-change-recovery-model-from-full-to-simple","tag-change-recovery-model-from-full-to-simple-script","tag-change-recovery-model-to-simple-for-all-databases","tag-changing-the-database-recovery-model","tag-find-database-recovery-model","tag-how-do-i-change-my-database-to-simple-recovery","tag-how-do-i-change-my-recovery-model-from-simple-to-full","tag-how-do-i-change-the-recovery-model-in-sql","tag-how-do-i-find-the-recovery-model-of-a-sql-server-database","tag-how-do-i-know-my-sql-recovery-model","tag-how-do-i-put-my-database-in-full-recovery-mode","tag-how-to-change-ms-sql-database-recovery-model","tag-query-to-find-recovery-model-of-all-databases-in-sql-server","tag-sql-server-change-recovery-model-from-full-to-simple","tag-sql-server-change-recovery-model-from-full-to-simple-script","tag-view-or-change-the-recovery-model-of-a-database"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Change Database Recovery Model in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change Database Recovery Model in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-30T06:45:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-22T12:45:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"672\" \/>\n\t<meta property=\"og:image:height\" content=\"404\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Change Database Recovery Model in SQL Server\",\"datePublished\":\"2018-05-30T06:45:02+00:00\",\"dateModified\":\"2020-10-22T12:45:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\"},\"wordCount\":272,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png\",\"keywords\":[\"Can I change recovery model from full to simple?\",\"change database recovery mode to bulk logged\",\"change database recovery mode to full\",\"change database recovery mode to simple\",\"change database recovery model\",\"change recovery model\",\"change recovery model from full to simple\",\"change recovery model from full to simple script\",\"change recovery model to simple for all databases\",\"Changing the Database Recovery Model\",\"Find database recovery model\",\"How do I change my database to simple recovery?\",\"How do I change my recovery model from simple to full?\",\"How do I change the recovery model in SQL?\",\"How do I find the recovery model of a SQL Server database?\",\"How do I know my SQL recovery model?\",\"How do I put my database in full recovery mode?\",\"How to Change MS SQL Database Recovery Model\",\"Query to find recovery model of all databases in SQL Server\",\"SQL Server change recovery model from full to simple\",\"SQL Server change recovery model from full to simple script\",\"View or Change the Recovery Model of a Database\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\",\"name\":\"Change Database Recovery Model in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png\",\"datePublished\":\"2018-05-30T06:45:02+00:00\",\"dateModified\":\"2020-10-22T12:45:46+00:00\",\"description\":\"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png\",\"width\":672,\"height\":404},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change Database Recovery Model in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change Database Recovery Model in SQL Server - Database Tutorials","description":"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Change Database Recovery Model in SQL Server - Database Tutorials","og_description":"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.","og_url":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2018-05-30T06:45:02+00:00","article_modified_time":"2020-10-22T12:45:46+00:00","og_image":[{"width":672,"height":404,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Change Database Recovery Model in SQL Server","datePublished":"2018-05-30T06:45:02+00:00","dateModified":"2020-10-22T12:45:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/"},"wordCount":272,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png","keywords":["Can I change recovery model from full to simple?","change database recovery mode to bulk logged","change database recovery mode to full","change database recovery mode to simple","change database recovery model","change recovery model","change recovery model from full to simple","change recovery model from full to simple script","change recovery model to simple for all databases","Changing the Database Recovery Model","Find database recovery model","How do I change my database to simple recovery?","How do I change my recovery model from simple to full?","How do I change the recovery model in SQL?","How do I find the recovery model of a SQL Server database?","How do I know my SQL recovery model?","How do I put my database in full recovery mode?","How to Change MS SQL Database Recovery Model","Query to find recovery model of all databases in SQL Server","SQL Server change recovery model from full to simple","SQL Server change recovery model from full to simple script","View or Change the Recovery Model of a Database"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/","name":"Change Database Recovery Model in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png","datePublished":"2018-05-30T06:45:02+00:00","dateModified":"2020-10-22T12:45:46+00:00","description":"In this article, we will change database recovery model in SQL Server via SSMS or script. And I will share some useful scripts.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/05\/Ads\u0131z-4.png","width":672,"height":404},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-database-recovery-model-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Change Database Recovery Model in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/10968"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}