{"id":559,"date":"2018-05-11T11:48:08","date_gmt":"2018-05-11T09:48:08","guid":{"rendered":"http:\/\/www.apvnorge.no\/?page_id=559"},"modified":"2020-01-06T07:22:45","modified_gmt":"2020-01-06T06:22:45","slug":"ms-sql","status":"publish","type":"page","link":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/","title":{"rendered":"MICROSOFT SQL"},"content":{"rendered":"<div id=\"apvno-3890432675\" class=\"apvno-before-content apvno-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7003427967427457\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:970px;height:250px;\" \ndata-ad-client=\"ca-pub-7003427967427457\" \ndata-ad-slot=\"6272152047\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/\">Back to  IT Knowledge Base <\/a><\/strong><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<ul class=\"wp-block-list\"><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/ms-sql\/how-to-set-all-databases-to-simple-recover-model-logging\/\">How to Set All Databases to Simple Recover Model (Logging)<\/a><\/strong><\/li><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/ms-sql\/how-to-increase-memory-for-sql-without-sql-management-console\/\">How to increase memory for SQL without SQL management console<\/a><\/strong><\/li><li><strong><a href=\"https:\/\/www.apvnorge.no\/it-knowledge-base\/ms-sql\/how-to-get-list-of-databases-from-sql-server\/\">How to get list of all databases<\/a><\/strong><\/li><\/ul>\n\n\n<h2><strong>&nbsp;<\/strong><\/h2>\n<p><\/p><div id=\"apvno-1825094567\" class=\"apvno-after apvno-entity-placement\"><script>\r\n_adsys_id = 33949;\r\n_adsys_size = 1;\r\n<\/script>\r\n<script src=\"https:\/\/d.wedosas.net\/d.js\"><\/script>    \r\n<\/br>\r\n<div>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- AD-4 -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:970px;height:250px\"\r\n     data-ad-client=\"ca-pub-7003427967427457\"\r\n     data-ad-slot=\"6272152047\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><\/div>\r\n<a href=\"https:\/\/affiliates.ssl.com\/820-3-1-13.html\" target=\"_blank\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" style=\"border:0px\" src=\"https:\/\/i0.wp.com\/affiliates.ssl.com\/media\/banners\/SSL-banner-UC-certificate-2-v5.png?resize=640%2C79&#038;ssl=1\" width=\"640\" height=\"79\" alt=\"Microsoft Exchange SAN UCC SSL\"><\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging) How to increase memory for SQL without SQL management console How to get list of all databases &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":437,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_exactmetrics_skip_tracking":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"class_list":["post-559","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.5","language":"no","enabled_languages":["en","no","cz"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"no":{"title":false,"content":false,"excerpt":false},"cz":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"google-site-verification\" content=\"TrS3Ce4SzthGp870C1FeMCHMy8m2nPpzG2NfPcdfJi0\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"nb_NO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Et teknologiselskap - Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MICROSOFT SQL - Et teknologiselskap\" \/>\n\t\t<meta property=\"og:description\" content=\"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&#038;ssl=1\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&#038;ssl=1\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-05-11T09:48:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-06T06:22:45+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100064041250396\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MICROSOFT SQL - Et teknologiselskap\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&amp;ssl=1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.apvnorge.no\\\/no\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/#listItem\",\"name\":\"IT Knowledge Base\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/#listItem\",\"position\":2,\"name\":\"IT Knowledge Base\",\"item\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#listItem\",\"name\":\"MICROSOFT SQL\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#listItem\",\"position\":3,\"name\":\"MICROSOFT SQL\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/#listItem\",\"name\":\"IT Knowledge Base\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/#organization\",\"name\":\"{:en}Et teknologiselskap{:}{:gb}Et teknologiselskap{:}\",\"description\":\"Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.\",\"url\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.apvnorge.no\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/APV.gif?fit=230%2C81&ssl=1\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#organizationLogo\",\"width\":230,\"height\":81},\"image\":{\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=100064041250396\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#webpage\",\"url\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/\",\"name\":\"MICROSOFT SQL - Et teknologiselskap\",\"description\":\"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases\",\"inLanguage\":\"nb-NO\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/it-knowledge-base\\\/ms-sql\\\/#breadcrumblist\"},\"datePublished\":\"2018-05-11T11:48:08+02:00\",\"dateModified\":\"2020-01-06T07:22:45+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/#website\",\"url\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/\",\"name\":\"{:en}Et teknologiselskap{:}{:gb}Et teknologiselskap{:}\",\"description\":\"Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.\",\"inLanguage\":\"nb-NO\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apvnorge.no\\\/no\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MICROSOFT SQL - Et teknologiselskap","description":"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases","canonical_url":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TrS3Ce4SzthGp870C1FeMCHMy8m2nPpzG2NfPcdfJi0","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no#listItem","position":1,"name":"Home","item":"https:\/\/www.apvnorge.no\/no","nextItem":{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/#listItem","name":"IT Knowledge Base"}},{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/#listItem","position":2,"name":"IT Knowledge Base","item":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#listItem","name":"MICROSOFT SQL"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#listItem","position":3,"name":"MICROSOFT SQL","previousItem":{"@type":"ListItem","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/#listItem","name":"IT Knowledge Base"}}]},{"@type":"Organization","@id":"https:\/\/www.apvnorge.no\/no\/#organization","name":"{:en}Et teknologiselskap{:}{:gb}Et teknologiselskap{:}","description":"Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.","url":"https:\/\/www.apvnorge.no\/no\/","logo":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=230%2C81&ssl=1","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#organizationLogo","width":230,"height":81},"image":{"@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=100064041250396"]},{"@type":"WebPage","@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#webpage","url":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/","name":"MICROSOFT SQL - Et teknologiselskap","description":"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases","inLanguage":"nb-NO","isPartOf":{"@id":"https:\/\/www.apvnorge.no\/no\/#website"},"breadcrumb":{"@id":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/#breadcrumblist"},"datePublished":"2018-05-11T11:48:08+02:00","dateModified":"2020-01-06T07:22:45+01:00"},{"@type":"WebSite","@id":"https:\/\/www.apvnorge.no\/no\/#website","url":"https:\/\/www.apvnorge.no\/no\/","name":"{:en}Et teknologiselskap{:}{:gb}Et teknologiselskap{:}","description":"Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.","inLanguage":"nb-NO","publisher":{"@id":"https:\/\/www.apvnorge.no\/no\/#organization"}}]},"og:locale":"nb_NO","og:site_name":"Et teknologiselskap - Dedisert til alle som ikke lenger kan reise til det vakre landet med oss.","og:type":"article","og:title":"MICROSOFT SQL - Et teknologiselskap","og:description":"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases","og:url":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/","og:image":"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&#038;ssl=1","og:image:secure_url":"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&#038;ssl=1","article:published_time":"2018-05-11T09:48:08+00:00","article:modified_time":"2020-01-06T06:22:45+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=100064041250396","twitter:card":"summary_large_image","twitter:title":"MICROSOFT SQL - Et teknologiselskap","twitter:description":"Back to IT Knowledge Base How to Set All Databases to Simple Recover Model (Logging)How to increase memory for SQL without SQL management consoleHow to get list of all databases","twitter:image":"https:\/\/i0.wp.com\/www.apvnorge.no\/wp-content\/uploads\/2018\/05\/APV.gif?fit=23081&ssl=1"},"aioseo_meta_data":{"post_id":"559","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"created":"2024-03-07 16:37:51","updated":"2025-06-03 23:38:54"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.apvnorge.no\/no\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/\" title=\"IT Knowledge Base\">IT Knowledge Base<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMICROSOFT SQL\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.apvnorge.no\/no"},{"label":"IT Knowledge Base","link":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/"},{"label":"MICROSOFT SQL","link":"https:\/\/www.apvnorge.no\/no\/it-knowledge-base\/ms-sql\/"}],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P9T0bk-91","jetpack-related-posts":[],"jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/pages\/559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/comments?post=559"}],"version-history":[{"count":22,"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/pages\/559\/revisions"}],"predecessor-version":[{"id":1695,"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/pages\/559\/revisions\/1695"}],"up":[{"embeddable":true,"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/pages\/437"}],"wp:attachment":[{"href":"https:\/\/www.apvnorge.no\/no\/wp-json\/wp\/v2\/media?parent=559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}