SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How make File/Filegroup Backup & restore Strategy
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pushp82
Yak Posting Veteran

81 Posts

Posted - 07/10/2012 :  06:34:41  Show Profile  Reply with Quote
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
35953 Posts

Posted - 07/10/2012 :  12:40:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
Why don't you just use snapshot replication?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pushp82
Yak Posting Veteran

81 Posts

Posted - 07/12/2012 :  05:26:59  Show Profile  Reply with Quote
thanks tkizer at last I applied the same (snapshot Rep)
quote:
Originally posted by tkizer

Why don't you just use snapshot replication?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35953 Posts

Posted - 07/12/2012 :  12:19:38  Show Profile  Visit tkizer's Homepage  Reply with Quote


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pushp82
Yak Posting Veteran

81 Posts

Posted - 07/05/2013 :  00:44:30  Show Profile  Reply with Quote
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?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000