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 |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2012-07-10 : 06:34:41
|
| Hi,I have two database live and beta both are exactly same now I need to update approx 15 tables from beta to live on daily bases (or on demand).I need to update all enteries of 15 tables like truncate and insert from beta.what I did :I created a secondry file group and added those 15 tables in that file group. now need to backup secondry group from beta and restore them on live on on demand.I'm not able to resore secondry file backup on live.How can I accomplish this task. what are the possible ways to acomplish this task.Please help.Pushp |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pushp82
Yak Posting Veteran
83 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2013-07-05 : 00:44:30
|
| but still there should be a way to accomplish this task through file group restoration. Do I need to restore primary file as well.any one has idea about this? |
 |
|
|
|
|
|
How make File/Filegroup Backup & restore Strategy
Tara Kizer