Update Sysfiles' title='Update Sysfiles' />How do I grow a database file MS SQL allocates more space than it needs.So your actual used database size is often much smaller than the allocated size.MS SQL allocates more space than it needs because the allocation of more data is pretty expensive and its more efficient to do it periodically instead of on each write to the DB.If you want to alter how much space is allocated at a time, you can use the FILEGROWTH parameter to set up the type of file growth youd like on your database.A value of 0 means there is no growth allowedXMB or XGB means to grow by that much when your DB current size is reachedX means to grow by that much percent when your DB current size is reached.ALTER DATABASE databasename MODIFY FILE NAME Ndatabasename, FILEGROWTH 1.GB. To free up the extra allocated space you can perform a DBCC SHRINKDATABASETo obtain the actual size of your database you can execute this SELECT size FROM sys. Best Software Program For Creating Slideshows On A Mac on this page. WHERE name databasename.To obtain the actual size of your database log you can execute this SELECT size FROM sys.WHERE name databasenamelog.Example SELECT output using SUBSTR.SUBSTR Character String Functions Oracle PLSQL Tutorial.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |