{"id":2602,"date":"2012-04-03T14:11:50","date_gmt":"2012-04-03T18:11:50","guid":{"rendered":"https:\/\/www.bumc.bu.edu\/it\/?page_id=2602"},"modified":"2012-05-01T09:08:41","modified_gmt":"2012-05-01T13:08:41","slug":"sql","status":"publish","type":"page","link":"https:\/\/www.bumc.bu.edu\/it\/support\/hosting\/sql\/","title":{"rendered":"SQL Database Hosting"},"content":{"rendered":"<table border=\"0\">\n<tbody>\n<tr>\n<th>Overview<\/th>\n<td>BUMC IT offers a central Microsoft SQL Server to support your databases needs.<\/td>\n<\/tr>\n<tr>\n<th>Available To<\/th>\n<td>Faculty\/Staff for non-personal, University needs.<\/td>\n<\/tr>\n<tr>\n<th>Benefits<\/th>\n<td>\n<ul type=\"disc\">\n<li>Databases are routinely protected with frequent backups, snapshots, and remote replicas.<\/li>\n<li>Servers are secured and managed centrally within a highly available cluster.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<th>Key Features<\/th>\n<td>\n<ul type=\"disc\">\n<li>Centrally      provisioned and managed service.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<th>Requirements<\/th>\n<td>\n<ul type=\"disc\">\n<li>Server must be on the campus network<\/li>\n<li>Server should have at least a 100Mb connection for optimal performance<\/li>\n<li>Backup services are only reasonably viable for data less than several terabytes.\u00a0 Beyond that, traditional backup is impractical.\u00a0\u00a0 (Contact the\u00a0<a href=\"http:\/\/www.bumc.bu.edu\/ithelp\">BUMC IT Service Desk<\/a> for alternatives.)<\/li>\n<li>Accounts accessing database(s) on SQL Server must be in AD (or AD2)<\/li>\n<li>Jobs associated with databases cannot rely on or make outgoing connections beyond the University network.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<th>Getting Started<\/th>\n<td><a href=\"http:\/\/www.bumc.bu.edu\/ithelp\">Contact the Service Desk<\/a> for more information.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Overview BUMC IT offers a central Microsoft SQL Server to support your databases needs. Available To Faculty\/Staff for non-personal, University needs. Benefits Databases are routinely protected with frequent backups, snapshots, and remote replicas. Servers are secured and managed centrally within a highly available cluster. Key Features Centrally provisioned and managed service. Requirements Server must be [&hellip;]<\/p>\n","protected":false},"author":5559,"featured_media":0,"parent":2610,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/pages\/2602"}],"collection":[{"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/users\/5559"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/comments?post=2602"}],"version-history":[{"count":3,"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/pages\/2602\/revisions"}],"predecessor-version":[{"id":3381,"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/pages\/2602\/revisions\/3381"}],"up":[{"embeddable":true,"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/pages\/2610"}],"wp:attachment":[{"href":"https:\/\/www.bumc.bu.edu\/it\/wp-json\/wp\/v2\/media?parent=2602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}