stripe single file to multiple files
Tech-Archive recommends: Speed Up your PC by fixing your registry
When adding files to a database's filegroup. What is the procedure to
ensure all data is equally distributed across the newly added files (so
that everything is efficiently striped).
I have tried two things so far.
1) add a 3rd file, empty the main file, empty and drop the 3rd file
2) dbcc dbreindex every table in the database
both of these methods help spread the data but neither come close to an
even split. Is there a common best practice to use here?
.
Relevant Pages
- Re: SQL Server 2005 - filegroup backup/restore problem
... I still have a problem of empty table after last backup/restore+recovery. ... now I can recover the database and make it online. ... Say that there is a SalesOrder table which is in the Primary group. ... If the filegroup would be available after the filegroup restore, ...
(comp.databases.ms-sqlserver) - Empty data files completely?
... Is there a way to completely empty some data files in the same filegroup so ... remove RmEaMkOnViEoTHvIoS from my email ...
(microsoft.public.sqlserver.server) - Re: Cant delete filegroup, even though it is empty
... Then use ALTER DATABASE to remove the filegroup. ... > I have a SQL 2000 database that I had created a seperate file group for to ... > cannot be removed because it is not empty' ...
(microsoft.public.sqlserver.server) - RE: filegroup
... You can move data to a different filegroup by rebuilding the clustered index ... When you have moved all your tables you can use the 'Alter database' command ... As you noted the filegroup must be empty first. ...
(microsoft.public.sqlserver.server) - Re: Any plans to remove obsolescent features?
... "" as an empty list ... Do you mean common outside of C, ... officially in the standard. ... I didn't say that compilers would have to reject "" as a syntax error; ...
(comp.std.c) |
|
