I am trying to figure out what the best way is to seperate data physically for example different companies. One simple way ofcourse is using different database for each company. Downside is maintenance.
Another solution is different filegroups for each company by creating a partition function with ranges and assigning the companyid column from different tables to the partition scheme. This way i've only one database to maintain. The problem with
this solution which i ran into is creating backups and restoring. Each filegroup can be accessed seperatly within the backup when using the partial key statement which is great. But lets say all companies want to return to their data from this
morning except company 3. If i take the backup from this morning and then restore the current log backup (made no logs in between) for filegroup company3 then all other companies(filegroups) have their current data also. I wonder if there is
an solution for this, am i doing something wrong or is it just not possible what i want?.
Restore sequence i use:
RESTORE DATABASE [Data Partition DB]
FILEGROUP = 'Primary'
WITH PARTIAL, NOUNLOAD, REPLACE, STATS = 10, NORECOVERY
RESTORE DATABASE [Dat
View Complete Post