| Author |
 Topic  |
|
|
pushp82
Yak Posting Veteran
67 Posts |
 Posted - 07/10/2012 : 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
USA
35007 Posts |
|
|
pushp82
Yak Posting Veteran
67 Posts |
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
| |
Topic |
|
How make File/Filegroup Backup & restore Strategy
