Red Gate forums :: View topic - Setting up Log Shipping under fire
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Setting up Log Shipping under fire

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
RichardRayJH



Joined: 21 Sep 2009
Posts: 13
Location: Teton Village, WY, USA

PostPosted: Sun Jan 12, 2014 7:53 pm    Post subject: Setting up Log Shipping under fire Reply with quote

I've got a production db that has users in it from 6:00 AM to 11:00 PM and runs batch processes from 11:30 PM to 1:00 AM. After that it does maintenance jobs to be RTG at 6:00 AM the next morning.

I want to set up log shipping. I've got another server ready to go, but I'm not clear on just what the steps are when the db is in production like that.

Does the target server need to have RedGate Backup Pro installed?

When should I take the backup that goes on the second server to be the basis for the log shipping?

How do I insure that the shipping starts up smoothly if the database is in use?

Am I making this harder than I need to? Smile
_________________
-
Richard Ray
Jackson Hole Mountain Resort
Teton Village, WY
Back to top
View user's profile Send private message Send e-mail
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Mon Jan 13, 2014 2:55 am    Post subject: Reply with quote

Quote:
Does the target server need to have RedGate Backup Pro installed?

Yes it does.

Quote:
When should I take the backup that goes on the second server to be the basis for the log shipping?

Usually off production hours so as not to affect your users' activities, but that would depend on how long the backup would take and if your production server has more than adequate CPU and disk I/O to spare for the backup.

Quote:
How do I insure that the shipping starts up smoothly if the database is in use?

You can take full and transaction log backups even when the database is in use.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group