January 16, 2012 at 5:13 pm
Hi - we currently have a database with one file group and multiple files spread over several disks. One disk is nearing capacity and as such that file has had autogrowth disabled.
My question is what about the tables in that file, what would happen should they require more space, would they automatically be added to another file in the filegroup?
Thanks
January 16, 2012 at 5:23 pm
With one filegroup, the data in the tables is spread across the files in that filegroup (unless partitioned which it doesn't sound like you are doing).
Thus, the tables are not assigned solely to one file in the filegroup and you will be fine.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply