July 10, 2017 at 9:18 am
I have a database where I have implemented view level partitioning. I have created separate file and file groups for each partition and have created the appropriate objects in the partitions within the database.
For example. database was created with a primary file and a log file, but I added 2 secondary files to contain 2 sets of data. I created separate file groups for and put each secondary file in their own file group.
I then created a schema for each file group(Group1, Group2)
I then created identical tables in each schema. Group1.TableA, Group1.Tableb, Group2.TableA, Group2.TableB
Now what I would like to do is figure out the best way to archive out the data in the Group2 schema. I am hoping I can figure out a way to do this at the file level without having to create a new database. The key is that I cannot just delete the Group2 data, I need to be able to keep it in case I need it in the future.
Any ideas would be greatly appreciated.
July 10, 2017 at 9:29 am
You can't move files or filegroups from one database to another, if that's what you were thinking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply