December 2, 2013 at 9:15 pm
Hi,
If a database is used only to read from, will its data files still grow? Only select queries are executed against the database, and there are no inserts/updates being carried out.
Thanks.
December 2, 2013 at 9:53 pm
Your database should not grow if it is readonly, but if you have complex select queries with lot of sorting, grouping then your tempdb will keep growing.
December 2, 2013 at 10:00 pm
Hi,
Thanks for the speedy reply.
The database is not set to read_only.
All users are restricted to db_datareader access. Only "Select" queries are run against the database. No users are permitted to execute insert/update/alter etc.
Thanks.
December 2, 2013 at 10:10 pm
through SELECT queries your database size will not grow however as i mentioned earlier tempdb might still grow also if you carry out any database maintenance tasks on this database then your log file will also grow.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply