November 4, 2008 at 1:45 pm
I am entering into the world of log shipping. After much reading I chose/suggested as a solution for high availability fail-over instead of replication (there are many schema changes taking place right now)
I am working with SQL Server 2000, but will very soon be upgrading to 2005 so I decided to post in here.
There are already jobs that kick off to backup the transaction log every hour. When I setup log shipping in a test environment I left those jobs there. For log shipping setup I decided to 'log ship' every 5 minutes. My question is: I should get rid of the hourly transaction logs shouldn't I, as 2 different scheduled are probably breaking the chain?
Does the same thing stand true for a database backup?
November 4, 2008 at 2:05 pm
Hi Suzanne,
Yes you're absolutely right, you can only have one chain of transaction log backups.
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 4, 2008 at 2:49 pm
Thank you so much for the quick response.
Can I also only have 1 backup?
Thanks again!!!
November 4, 2008 at 3:14 pm
Hi,
Yes you can, more information is available here: http://msdn.microsoft.com/en-us/library/ms191429(SQL.90).aspx "Creating Transaction Log Backups".
🙂
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply