The assumption is that we have a single very large file which This database has one table and one filegroup at the beginning of the engagement вЂ“ We have a SQL Server instance containing one user database called KairosTraining. Filegroup вЂ“ Filegroups in SQL Server are used to groupДata files together for administrative, data allocation and placement purposes.ДЇilegroups provide an abstraction layer between database objects such as tablesДЄnd indexes and the actual physical files sitting on the operating system.System blocks that hold your actual data. Datafile вЂ“ A physical file that contains the operating.To better understand this article, the following definition of terms will help: Note: Separate disks may mean different things to different people depending on One key solution is to identify the largest tables in your primary file groupДЄnd rebuild the table(s), directing the data to another file group which you haveД¬reated with multiple data files possibly on separate disks. To migrate data files smoothly using the detach and attach method. Such large data files may present managementДifficulties such as the case where you cannot take The primary data file is unnecessarily huge.

There are situations where a SQL Server databases is handed over to you and you find that By: Kenneth Igiri | Updated: | Comments (4) | Related: More > Database Configurations

Smartsvn merge across different files