Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Soulweaver
Starting Member
18 Posts |
 Posted - 2002-11-26 : 06:40:26
|
| HelloWe have a 185gb database in our production SQL Server 7 SP2 environment. It consists of two filegroups, one with the image table (140gb) and one with the rest of the data (45gb).How , we make a weekly full backup of this database every weekend and differential backups every day. We also make 6 transaction log backups during various times in the day.These backups are used daily to create a copy of the previous day's production environment for the accounting and various other people that need access to production data.To do this, we restore daily the weekly full backup, apply the differential to it, and run various scripts to make it available to everyone.Now, what we want to know, is , is there a way to only get back the primary filegroup, (aka, no image table), and not restore the image table AT all.The reasoning is, the 'other' people who need the copy, doesn't need the image information (its merely scans of the issueing documents etc). and if we can save time for the full restore, that would be great. Currently, if we need to give a backup to the production support environment to test their data fixes etc, we remove the image table using a truncate and a shrink (which is VERY VERY fast because of the filegroup), however, we still need the full 185gb to restore before we can truncate and shrink.So the question, is whether or not we can restore the primary filegroup only even if only from the full backup, and allow us to remove the 'vestiges' of the image table and thus have an 'in sync' database?What do you recommend we do?ThanksTiaan-----------------------Black Holes exist where God divided by Zero----------------------- |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-11-26 : 18:14:10
|
| I'm not sure if this is possible in SQL7. In SQL2000 you can use the PARTIAL option of the restore command however I believe this was not in SQL7 (can't remember).HTHJasper Smith |
 |
|
|
|
|
|
|
|
Handling Filegroups with VLDB