SQL Server Best Practices: Setting a Default Filegroup

re: SQL Server Best Practices: Setting a Default Filegroup

BuckWoody — Thu, 23 Sep 2010 13:43:43 GMT

Gustavo - Filegroups are at the database level.

re: SQL Server Best Practices: Setting a Default Filegroup

Gustavo Longo — Thu, 23 Sep 2010 12:34:51 GMT

Hi Buck, is possible define a default filegroup in the server level?

My idea is define a default filegroup before create to any database.

Thanks,

re: SQL Server Best Practices: Setting a Default Filegroup

BuckWoody — Fri, 19 Jun 2009 21:56:50 GMT

Tom - you are correct. I always do it in a separate step so that I can pull it out for an ALTER statement on an existing system.

re: SQL Server Best Practices: Setting a Default Filegroup

Tom Groszko — Fri, 19 Jun 2009 21:01:34 GMT

I don't understand why you describe an additional step is needed. The filegroup statement on the CREATE DATABASE command allows you to specify DEFAULT. What is accomplished by doing this in a seperate step?

Tom

re: SQL Server Best Practices: Setting a Default Filegroup

BuckWoody — Fri, 22 May 2009 00:56:14 GMT

Mark, you are so correct. My original post had "master model and msdb" - but what I meant to say was "system tables". The system databases are of course, well, databases, so they have their own filegroups!

re: SQL Server Best Practices: Setting a Default Filegroup

Mark Hions — Fri, 22 May 2009 00:42:06 GMT

Buck may have post-TechEd flu. The PRIMARY filegroup does *not* hold master, model, and msdb. Those are system databases, and they contain PRIMARY filegroups of their own.

I think he meant to say that the PRIMARY filegroup holds the database metadata, aka system tables. They are not accessible normally. I agree with the recommendation to make another, non-PRIMARY filegroup become the default, however.

re: SQL Server Best Practices: Setting a Default Filegroup

johnw73 — Thu, 21 May 2009 19:32:45 GMT

Buck, could you clarify 'This is also the Filegroup that holds your master, msdb, tempdb and other objects.'? I have a feeling that this is the crux of your post, but when I read it, i infer that ANY filegroup named PRIMARY is shared, which I didn't expect.

SQL Server Best Practices: Setting a Default Filegroup | Microsoft Share Point

SQL Server Best Practices: Setting a Default Filegroup | Microsoft Share Point — Thu, 21 May 2009 17:07:16 GMT

PingBack from http://microsoft-sharepoint.simplynetdev.com/sql-server-best-practices-setting-a-default-filegroup/