Tag Info

New answers tagged

4

The following SQL will show you which file groups your tables and indexes are in which will make it easy to see if there is data in any file group that shouldn't have data. SELECT f.[name] AS FileGroupName , o.[name] AS ObjectName , o.[type] AS [Type] , i.[name] AS IndexNAme , i.[index_id] AS IndexId ...


2

Since the database is ONLINE, you have two main options: Create a new database with the same schema for [PRIMARY] filegroup objects as the old database, and transfer data using any of the tools available (e.g. SSIS, bcp, linked server). Depending on the complexity of the existing schema, constraints, and relationships (e.g. foreign keys) this may be quite ...



Top 50 recent answers are included