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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-07-01 : 13:17:44
|
| We have a partition for each month and it is allocated on seperate filegroups. so we are thinking at month end we will mark this filegroup as readonly and take a filegroup backup. Now after 6 months due to archiving strategy we need to drop all objects in this filegroup to free up space so since we already had a readonly backup of this filegroup, we will change to readwrite and drop all objects and filegroup as well. And if someone needs the data later on they can just restore the readonly filegroup backup.But when i am experimenting with this scenario somehow sql server and forcing me to apply all the logs after i applied the filegroup backup but since logs contains the drop table statements i am not able to recover any objects in filegroup.Which step i am doing wrong and what should be the correct procedure?Thanks--rubs |
|
|
|
|
|
Filegroup Recovery question