muthyala_51 (1/22/2014)
Steve,Can you help me to find that article or elaborate on that technique which you are referrring to?
As follows
ALTER DATABASE olddata ADD FILEGROUP newFG
ALTER DATABASE olddata ADD FILE(NAME=somename, FILENAME = 'drive:\path\somefile.NDF', SIZE = 10GB, MAXSIZE = 20GB, FILEGROWTH = 1GB)
CREATE CLUSTERED INDEX [someindex] on schema.table (somecolumn)
WITH (DROP_EXISTING=ON) ON [newFG]
ALTER DATABASE olddata MODIFY FILEGROUP newFG READ_ONLY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉