SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:03 PM
| ||||
| ||||
 restrict filegrowth I think it'll be the same as your database or transaction log run out of space, it will only affect the particular db as long as it do not cause other db run out of space too. This can be happen if you place the data on the same disk and the disk is run out of space too. By setting the max file growth, you are doing a good practice to ensure that if the space is run out, it won't cause the disk to be completely full, even if your server only have one harddisk (it means all the OS, Programs, DB, and logs are in one place). Read Books Online to solve the insufficient disk space error (error 9002 and 1105). In the Index type 'disk space' keyword and then choose 'Insufficient disk space'. Hope it helps..  Regards, Jono Indrawijaya - MCDBA PT. eBiz Cipta Solusi - Microsoft Certified Partner Indonesia >-----Original Message----- >Hi All >What will happen if in the middle of uploading data to SQL >server it exceed the max file growth size? Will this only >affect that particular db or the whole server? thanks > >cheeers >Ken >. >      |
Linear Mode
