April 29, 2009 at 8:52 am
Hi,
I have a large database (17 terabytes) that cannot be full backed up. I create a new filegroup every month and the users create the new tables there, then I back up the previous one and set it to read-only. I need to restore some of the filegroups on another server but I have no clue on how to do it since there is no full backup to begin with.
April 29, 2009 at 9:24 am
Can you create an empty copy of the database, then add the filegroups to that?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 29, 2009 at 10:42 am
How can I do that?
April 29, 2009 at 10:44 am
create a database, with filegroups and files, and then copy over the schema. You can move tables one by one and specify on which filegroup they work on.
April 29, 2009 at 10:52 am
Actually, we are setting up a disaster recovery site, so I need to restore the filegroups from tape backups, assuming the production database is down. Also, some of the tables have more than 600 million records, and I don't know if importing would work. I am using sql server 2000.
April 29, 2009 at 1:12 pm
I found some information on how to do this and it is way too complicated for a large database with 80 filegroups (and growing!). So I think I will create 80 different databases on the same server and back them up individually. The core database and the latest one (the one that is being used the current month) will be the two only online dbs, the other 78 will be set to read-only. Any thoughts?
April 30, 2009 at 6:43 am
That does sound like a better idea than separate filegroups in the database.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply