Idea Excursion
Technology Musings
Here’s a quick little statement you can use to verify the size and growth settings for a SQL Server database. It doesn’t spell everything out for you, but if you’re aware of some common conventions (-1 = unlimited, 0 = no growth), it’s a fast and easy way to verify settings before issuing your ALTER DATABASE command. The filename is commented out by default, but provided just-in-case.
SELECT DB_NAME() [DATABASE] , name [Logical Name] , CEILING(SIZE/128.0) [SIZE (MB)] , CASE maxsize WHEN -1 THEN maxsize ELSE CEILING(maxsize/128.0) END [MaxSize (MB)] , CASE WHEN (status & 0x100000) = 0 THEN CEILING(growth/128.0) ELSE growth END [Growth] , CASE WHEN (status & 0x100000) = 0 THEN 'MB' ELSE '%' END [% or MB] --, filename FROM sysfiles
Some example output:
Database Logical Name Size (MB) MaxSize (MB) Growth % or MB ReportServer ReportServer 18 -1 1 MB ReportServer ReportServer_log 177 2097152 10 %
And an image from SSMS to verify:
- Tags: HOWTO, SQL Server, SSMS
Comment Form
Categories
- Google (6)
- Gmail (1)
- Hardware (1)
- Internet (3)
- iPhone (6)
- Linux (12)
- Mac (3)
- Microsoft (39)
- Dynamics AX (1)
- Windows (36)
- Active Directory (2)
- SQL Server (25)
- SSIS (6)
- VirtualBox (13)
- HOWTO: Sync Google Calendar on iPhone OS 3.0
- HOWTO: Setup SQL Server Linked Server to MySQL
- Windows 7 in VirtualBox: Shared Folders workaround
- Connecting to Oracle from SQL Server
- Installing Windows 7 Beta 1 in VirtualBox 2.1.0
- HOWTO: Synchronize Dropbox and ZumoDrive on Windows
- Efficiently query the DATE in DATETIME
- Fixing "passwd: Authentication token manipulation error" when changing passwords
- All About Linux Swap Part 2: Management
- All About Linux Swap Part 3: Analysis
- Cache multiple values in a Map Container for fast in-memory lookup
- Ubuntu VirtualBox Server Redux Addendum
- Default column value to identity of different column
- Ubuntu VirtualBox Server Redux
- Updating SSH known hosts fingerprints (WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)
- HOWTO: Create Email Forwarders in Google Apps
- Import Excel 2007 with SQL Server Import and Export Wizard
- Firefox 3.6 Beta 3 now available
- Microsoft Office 2010 Beta posted on MSDN/TechNet
- Accessing Custom .NET Assemblies in SSIS 2008 Script Tasks
- Yushe » Blog Archive » Conectar SQL Server con MySql: [...] Disclaimer: El árticulo arriba no es mio, es solo una traducción parcial del árticulo aqui [...]
- Nick: Here is an extensive how to on sharing folders with Windows 7. http://www.ilertech.com/2010/09/shar [...]
- dushyant kayarkar: I attempted to update my password on Ubuntu today and encountered a strange error. I thought I’d d [...]
- Prakash - Savvysoft Technologies: USE master GO -- To use named parameters: Add linked server in the source (Local machine - eg: Mac [...]
- Mike: Doh! The inprocess flag was killing me. Thanks. [...]