Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesGreetings Group Members, I am going to implement a strategy for archiving and restoring old filegroups. Part of my data has been stored in date partitioned files and filegroups. So the archive is going to backup older than six months filegroups into the tape and removes them from the production database. The restore strategy is going to work as this: user would be able to ask for restoring old filegroups. Every time there is a restore request, first I am going to restore the current PRIMARY filegroup of production database into another instance of SQL Server and then restore the requested filegroup to the new SQL Server as well. My question is if this restore strategy is possible to be done? I mean is that possible to restore an old filegroup and a current PRIMARY fileroup and keep the consistency and send queries against them? Regards,
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread