{"id":238,"date":"2012-06-04T08:35:02","date_gmt":"2012-06-04T08:35:02","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/04\/backup-types-in-sql-server\/"},"modified":"2012-06-04T08:35:02","modified_gmt":"2012-06-04T08:35:02","slug":"backup-types-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/04\/backup-types-in-sql-server\/","title":{"rendered":"backup types in sql server"},"content":{"rendered":"<p><strong>Following are the Backup types in SQL Server 2008:<\/strong><\/p>\n<ul>\nFull backup<br \/>\nDifferential backup<br \/>\nPartial backup<br \/>\nDifferential partial backup<br \/>\nFile backup<br \/>\nDifferential file backups<br \/>\nTransaction Log Backups<br \/>\nCopy-Only Backups<\/ul>\n<p>More details <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/ms175477(v=sql.105).aspx\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Following are the Backup types in SQL Server 2008: Full backup Differential backup Partial backup Differential partial backup File backup Differential file backups Transaction Log Backups Copy-Only Backups More details here<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[137],"tags":[2087,2088,2089,2090,2091,2092],"class_list":["post-238","post","type-post","status-publish","format-standard","hentry","category-databasebackup","tag-database-backup-types-in-sql-server","tag-database-backup-types-in-sql-server-2005","tag-database-backup-types-in-sql-server-2008","tag-database-backup-types-in-sql-server-2008-r2","tag-database-backup-types-in-sql-server-2012","tag-what-are-the-different-database-backup-types-in-sql-server"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=238"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/238\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}