balasach82 (5/7/2013)
3. If the deleting filegroup is set as DEFAULT, then how to delete it and what would be the premove steps
Delete all the objects in that filegroup. Delete all the files. Set another filegroup as default.
4. if "SELECT * INTO" is used to create tables, it would alo be going to Default FG. Correct?
Any time that a filegroup is not specified, the object goes to the default filegroup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability