September 29, 2003 at 9:21 pm
if i did n't specify auto grow option to my database
i)what will happen to my database.
ii) if it crashes how to retreive from it
regards
balaji
balaji ramanar
balaji ramanar
September 30, 2003 at 1:35 am
In access?
Keith Henry
DBA/Developer/BI Manager
Keith Henry
September 30, 2003 at 7:50 am
You posted in the Access forum, but I'll answer as though you meant SQL Server.
You can't do a restore unless you have backups. Autogrow has NOTHING to do with backup and restores.
If you don't allow autogrow, your database won't grow when it needs more room. You will have to manually grow (resize) the database before you can add any more information to your tables.
For example: your database is 100MB and it currently has 98MB of data. You want to INSERT some data that will need 5 MB of space. The database 'refuses' the data because it would go over the 100MB limit (it needs 103MB). So, the INSERT fails. The database doesn't crash, the transaction just fails and does a rollback.
So, you need to ALTER DATABASE to increase the size and then re-run the INSERT.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply