Subject | Re: Possible bug in RC8 -Finding out size of database through code from client |
---|---|
Author | Ian A. Newby |
Post date | 2004-01-14T10:36:53Z |
Hi GOVINDKRISHNA
Why do you need to add new files? 1.0 and above support files
larger that 2gb (on platforms that support it).
Also you can pre-allocate secondary files without backing up and
restoring, by using ALTER DATABASE I believe. They will take up
negligable space until the database requires them. So you could pre-
allocate 10 secondary files giving you a safe size of 20GB.
Alternatively, you could run an app/script on the server which
checked the file size of the database files and use this information.
Regards
Ian Newby
Why do you need to add new files? 1.0 and above support files
larger that 2gb (on platforms that support it).
Also you can pre-allocate secondary files without backing up and
restoring, by using ALTER DATABASE I believe. They will take up
negligable space until the database requires them. So you could pre-
allocate 10 secondary files giving you a safe size of 20GB.
Alternatively, you could run an app/script on the server which
checked the file size of the database files and use this information.
Regards
Ian Newby