{"id":1787,"date":"2016-06-16T08:16:24","date_gmt":"2016-06-16T06:16:24","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=1787"},"modified":"2016-06-16T08:16:24","modified_gmt":"2016-06-16T06:16:24","slug":"microsoft-sql-server-express-wie-man-die-datenbankgroesse-herausfindet-how-to-get-the-database-size","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=1787","title":{"rendered":"Microsoft SQL Server Express: Wie man die Datenbankgr\u00f6\u00dfe herausfindet \/ How-to get the Database size"},"content":{"rendered":"<h1>Pr\u00e4misse<\/h1>\n<p>Bei MS SQL Server 2012 Express und 2014 Express darf die maximale Datenbankgr\u00f6\u00dfe nur 10 GB betragen. <\/p>\n<h1>Problem<\/h1>\n<p>Wie findet man die Datenbankgr\u00f6\u00dfe heraus?<\/p>\n<h1>Ansatz<\/h1>\n<p>SQL Server Server Statement<\/p>\n<h1>L\u00f6sung &#8211; Solution<\/h1>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nSELECT \r\n      database_name = DB_NAME(database_id)\r\n    , log_size_mb = CAST(SUM(CASE WHEN type_desc = &#039;LOG&#039; THEN size END) * 8. \/ 1024 AS DECIMAL(8,2))\r\n    , row_size_mb = CAST(SUM(CASE WHEN type_desc = &#039;ROWS&#039; THEN size END) * 8. \/ 1024 AS DECIMAL(8,2))\r\n    , total_size_mb = CAST(SUM(size) * 8. \/ 1024 AS DECIMAL(8,2))\r\nFROM sys.master_files WITH(NOWAIT)\r\nWHERE database_id = DB_ID() -- for current db \r\nGROUP BY database_id\r\n<\/pre>\n<iframe src=\"http:\/\/www.facebook.com\/plugins\/like.php?href=https%3A%2F%2Fwww.capri-soft.de%2Fblog%2F%3Fp%3D1787&amp;layout=standard&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light\" scrolling=\"no\" frameborder=\"0\" allowTransparency=\"true\" style=\"border:none; overflow:hidden; width:450px;margin-top:5px;\"><\/iframe>","protected":false},"excerpt":{"rendered":"<p>Pr\u00e4misse Bei MS SQL Server 2012 Express und 2014 Express darf die maximale Datenbankgr\u00f6\u00dfe nur 10 GB betragen. Problem Wie findet man die Datenbankgr\u00f6\u00dfe heraus? Ansatz SQL Server Server Statement L\u00f6sung &#8211; Solution SELECT database_name = DB_NAME(database_id) , log_size_mb = CAST(SUM(CASE WHEN type_desc = &#039;LOG&#039; THEN size END) * 8. \/ 1024 AS DECIMAL(8,2)) , &hellip; <a href=\"https:\/\/www.capri-soft.de\/blog\/?p=1787\" class=\"more-link\"><span class=\"screen-reader-text\">Microsoft SQL Server Express: Wie man die Datenbankgr\u00f6\u00dfe herausfindet \/ How-to get the Database size<\/span> weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11],"tags":[],"class_list":["post-1787","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4yGeN-sP","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1787"}],"version-history":[{"count":1,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787\/revisions"}],"predecessor-version":[{"id":1788,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1787\/revisions\/1788"}],"wp:attachment":[{"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.capri-soft.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}