April 17, 2008 at 3:58 am
Hi there,
I hav a question regarding backups and log shipping.
We have a database which is backed up every night, and during the day transaction log backups are made.
For performance reasons we intend to do log shipping as well.
Is it possible to have log shipping and my regular backups next to each other or do i have to choose between the two ?
Jurgen
April 17, 2008 at 9:01 pm
When configuring log shipping what you are essentially doing is configuring a backup scheme that will perform the following steps:
1. Run a log backup
2. Restore the backups to a standby database
(Of course I am leaving out the whole initial step of snapshotting the database initially to set up the standby database, but hey, that was not part of your question.) The point is that you do not need to maintain two sets of log backups.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
April 19, 2008 at 3:23 am
AOA
log shipping is used for preparing servers with specific databases. usually organisations use these to create server copies for distribution to their sites. You should not include it in your routine backup restore stretigy. It will be inefficient.
DBDigger Microsoft Data Platform Consultancy.
April 19, 2008 at 11:41 am
well, thx for the advice
April 21, 2008 at 3:25 pm
Log shipping is for DR, if you backup the logs with log shipping you will blow up the log shipping
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply