{"id":69268,"date":"2021-08-16T04:10:06","date_gmt":"2021-08-16T08:10:06","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/sql-server-backups-38\/"},"modified":"2021-08-16T04:10:06","modified_gmt":"2021-08-16T08:10:06","slug":"sql-server-backups-38","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69268","title":{"rendered":"SQL Server : Backups #38"},"content":{"rendered":"<p><b>Why are backups needed?<\/b> <\/p>\n<p>To protect accidental data loss. Still, if you use highly available and fault-tolerant systems like SAN, and RAID, you may need to backup your database regularly. These fault tolerant systems can not provide accidental data delete by users, accidental data corruption from software and hardware failure. If you have a disaster recovery site or a secondary datacenter to where all data are replicated and data changes are stored, then you may not need backup but otherwise regular backups are always useful.<\/p>\n<p>Data backup can restore data until the last backup. . Transaction Logs may help to restore data up to the point of failure. Restore data from the data backup, then if you have the transaction log up to the failure apply it to the data.<\/p>\n<p><b>SQL Server Recovery Models:<\/b><\/p>\n<ul>\n<li> Simple Recovery Model. Transaction logs are not used<\/li>\n<li> Full Recovery Model: Use both data and transaction log backups<\/li>\n<li>Bulk-logged recovery model: Like full recovery model. But here bulk operations are minimally logged to the transaction log. So full recovery becomes faster.<\/li>\n<\/ul>\n<p><b>Types of Backups<\/b><\/p>\n<ul>\n<li> Full database backup: Full database, all files and file groups are backed up   <\/li>\n<li> Partial Back up:  It&#8217;s not the differential backup. Here, all primary file groups and any other file groups that are read-write are backed up. But read-only file groups are not backed up by default.    <\/li>\n<li> File or file group backup: Usefull when full back ups take too long. Backup in parts.   <\/li>\n<li>Differential back up: Backup only the changes. Should be applied to a full backup.  <\/li>\n<li>Log backup: In log back ups, transaction logs are backed up regularly. It helps in bulk logged recovery model and full recovery model. <\/li>\n<li>Copy only backups: <\/li>\n<li> Full text catalog backups<\/li>\n<\/ul>\n<p>Knowing about backup devices, media sets, and backup history  tables is also important.<\/p>\n<p>Mirrored Media Sets: Backup data to more than one media at the same  time.<\/p>\n<p><b>Backup Strategy:<\/b><\/p>\n<p>Based on your company need and type of data, you should come up with a backup strategy.<\/p>\n<p><b>Some backup strategies<\/b><\/p>\n<p><b>Strategy &#8211; 1<\/b><\/p>\n<ol>\n<li> Take full database backup every saturday night <\/li>\n<li> Take a differential backup every wednesday night <\/li>\n<li> Perform, continual transaction log backups every 30 minutes<\/li>\n<\/ol>\n<p><b>Strategy &#8211; 2:<\/b> If the database is too big, and user activities need continuous uptime and optimal performance<\/p>\n<ol>\n<li> Filegroup 1 backup every saturday night <\/li>\n<li> Filegroup 2 backup every sunday night <\/li>\n<li> File group 1 differential backup every Tuesday night <\/li>\n<li> File group 2 differential backup every wednesday night <\/li>\n<li> File group 1 differential backup every Thursday night <\/li>\n<li> File group 2 differential backup every Friday night <\/li>\n<li> Perform, continual transaction log backups every 30 minutes<\/li>\n<\/ol>\n<p><b>Backup System Databases<\/b> <\/p>\n<p>It is also important to back up system databases like master, model, msdb, tempdb, distribution, resource.<\/p>\n<p>From: http:\/\/sitestree.com\/?p=4837<br \/> Categories:38<br \/>Tags:<br \/> Post Data:2011-02-01 01:27:56<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Why are backups needed? To protect accidental data loss. Still, if you use highly available and fault-tolerant systems like SAN, and RAID, you may need to backup your database regularly. These fault tolerant systems can not provide accidental data delete by users, accidental data corruption from software and hardware failure. If you have a disaster &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69268\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69268","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":23008,"url":"http:\/\/bangla.sitestree.com\/?p=23008","url_meta":{"origin":69268,"position":0},"title":"SQL Server Concepts Generate Scripts, Export and Import Data, Database Backup and Restore #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 23, 2021","format":false,"excerpt":"[youtube http:\/\/www.youtube.com\/watch?v=NC98qRdnapc&w=640&h=390] From: http:\/\/sitestree.com\/?p=1891 Categories:Root, By Sayed AhmedTags: Post Data:2015-01-15 19:47:34 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69260,"url":"http:\/\/bangla.sitestree.com\/?p=69260","url_meta":{"origin":69268,"position":1},"title":"Scaling Out #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Methods SQL Server instances Clustering Database mirroring Log shipping Replication Shared scalable databases SQL Server instancesIn the same computer install multiple instance of SQL Server to take advantage of multiple processors. Each instance may use separate processor with separate lock manager, worker threads, tempdb system database. ClusteringFailover Clustering can provide\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26158,"url":"http:\/\/bangla.sitestree.com\/?p=26158","url_meta":{"origin":69268,"position":2},"title":"Magento Misc #Root","author":"Author-Check- Article-or-Video","date":"April 18, 2021","format":false,"excerpt":"How do I change to developer mode on aws lightsail magento? For AWS lightsail: cd \/apps\/magento\/htdocs php bin\/magento deploy:mode:set developer--- Enable backups The Magento backup feature is disabled by default. To enable, enter the following CLI command: bin\/magento config:set system\/backup\/functionality_enabled 1 From: http:\/\/sitestree.com\/magento-misc\/ Categories:RootTags: Post Data:2019-08-13 15:21:08 Shop Online: https:\/\/www.ShopForSoul.com\/\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":5768,"url":"http:\/\/bangla.sitestree.com\/?p=5768","url_meta":{"origin":69268,"position":3},"title":"SQL Server \u09a1\u09be\u099f\u09be \u09ac\u09cd\u09af\u09be\u0995\u0986\u09aa \u098f\u09ac\u0982 SQL \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u0964 SQL Server Concepts Generate Scripts, Export and Import Data, Database Backup and Restore","author":"Sayed","date":"January 15, 2015","format":false,"excerpt":"SQL Server \u09a1\u09be\u099f\u09be \u09ac\u09cd\u09af\u09be\u0995\u0986\u09aa \u098f\u09ac\u0982 SQL \u09b8\u09cd\u0995\u09cd\u09b0\u09bf\u09aa\u09cd\u099f \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u0964 SQL Server Concepts Generate Scripts, Export and Import Data, Database Backup and Restore","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65718,"url":"http:\/\/bangla.sitestree.com\/?p=65718","url_meta":{"origin":69268,"position":4},"title":"On Thursday and Friday tar all contents of \/etc folder into \/export\/home\/shell\/test\/etc.tar .. do misc logs #Linux\/Unix: Shell Programming &#8211; 001","author":"Author-Check- Article-or-Video","date":"July 12, 2021","format":false,"excerpt":"#!\/bin\/ksh # on every thursday and friday tar all contents of \/etc folder into \/export\/home\/shell\/test\/. On thursday only create a log file with the list of files #in the tar file. On thursday untar \/export\/home\/shell\/test\/etc.tar into vfstab . Then log vfstab exist or not information DAY=`date +%a` DATESTAMP=`date +%m-%d-%Y-%H:%M` if\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69091,"url":"http:\/\/bangla.sitestree.com\/?p=69091","url_meta":{"origin":69268,"position":5},"title":"MySql Administration SQL Commands #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Using MySQL, AdministrationWorkshop RequirementsYou should have access to the MySQL command line client software.Various different PRIVILEGES on the MySQL ServerIntroductionIn the other MySQL Virtual Workshops we have used commands that are pretty much applicable to anyone. This part of the MySQL series is aimed at giving a rudimentary understanding of\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69268"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69268\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69268"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}