November 19, 2012 at 7:28 am
Hi All,
I need database help for the below scenario. We have a database with the below filegroup structure
Database filegroups :
=======================
1.Primary filegroup
2.Seconary1 filegroup - Secondary
3.Secondary2 filegroup - Secondary
4.Secondary3 filegroup - Secondary and so on
Initially I want to backup the Primary, Secondary1 and Secondary2 filegroups and restore them on a different server(server A).
After some days time(may be after a gap of 1 day) I need to backup and restore only the Secondary2 filegroup on the server(Server A) but at the same time not affect the data that was initially restored using Primary and Secondary1 filegroups. At the end all the data in primary and secondary filegroups need to be online and queryable.
Kindly help if anybody has faced a similar scenario in past and were able to resolve it.
Thank You!
November 19, 2012 at 9:36 am
SSIS developer (11/19/2012)
I need to backup and restore only the Secondary2 filegroup on the server(Server A) but at the same time not affect the data that was initially restored using Primary and Secondary1 filegroups.
Cannot be done.
When you restore the other filegroups you will have to restore log backups to bring all filegroups back to the same point in time. You cannot have a DB where some filegroups are as of one time and others are as of another.
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