locked
a file group and later change it to Default RRS feed

  • Question

  • I have created a file group and later change it to Default then what will happen with default file group?
    "SQLSERVER DBA" "INDIA"
    Friday, October 1, 2010 7:09 AM

Answers

  • Right Click on database, Properties > Filegroups
    Choose whichever you want as default.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by Grace Liu Monday, October 4, 2010 9:11 AM
    • Marked as answer by Ajay.G Tuesday, October 5, 2010 10:25 AM
    Friday, October 1, 2010 10:26 AM

All replies

  • Not clear with the question.
    As per books online

    {
    Default Filegroup
    When objects are created in the database without specifying which filegroup they belong to, they are assigned to the default filegroup. At any time, exactly one filegroup is designated as the default filegroup. The files in the default filegroup must be large enough to hold any new objects not allocated to other filegroups.

    The PRIMARY filegroup is the default filegroup unless it is changed by using the ALTER DATABASE statement. Allocation for the system objects and tables remains within the PRIMARY filegroup, not the new default filegroup.
    }


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, October 1, 2010 7:13 AM
  • Than BalMukund,

    That is my conusion Now I want to again makes primary filegroup as default not the user defined file group .Is it possible?

     


    "SQLSERVER DBA" "INDIA"
    Friday, October 1, 2010 10:15 AM
  • Right Click on database, Properties > Filegroups
    Choose whichever you want as default.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by Grace Liu Monday, October 4, 2010 9:11 AM
    • Marked as answer by Ajay.G Tuesday, October 5, 2010 10:25 AM
    Friday, October 1, 2010 10:26 AM