1.0https://www.w3computing.com/sqlserver2012w3compadminhttps://www.w3computing.com/sqlserver2012/author/w3compadmin/Altering a Database - ALTER DATABASE statement - SQL Serverrich600338<blockquote class="wp-embedded-content" data-secret="wabQ3lfESM"><a href="https://www.w3computing.com/sqlserver2012/altering-database-alter-statement/">Altering a Database – ALTER DATABASE statement</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.w3computing.com/sqlserver2012/altering-database-alter-statement/embed/#?secret=wabQ3lfESM" width="600" height="338" title="“Altering a Database – ALTER DATABASE statement” — " data-secret="wabQ3lfESM" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.w3computing.com/sqlserver2012/wp-includes/js/wp-embed.min.js
</script>
The ALTER DATABASE statement changes the physical structure of a database. The Transact-SQL language allows you to change the following properties of a database: Add or remove one or more database files Add or remove one or more log files Add or remove filegroups Modify file or filegroup properties Set database options Change the name […]http://www.w3computing.com/sqlserver2012/wp-content/uploads/sites/5/2017/09/5.1-SQL-Server-Properties-FILESTREAM-tab-262x300.png