SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logshipping - Need full backup of Sencondary Database


Logshipping - Need full backup of Sencondary Database

Author
Message
ravisamigo
ravisamigo
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1489 Visits: 760
Hi,

We've SQLServer 2005 logshipping configured on one of production database and the size of this db is around 1 TB. It will take more time to take the backup of the primary database every time.

Not possible to take the backup of secondary database because it is in Restoring phase.

So, please advice how we can take full backup from secondary database or is there any alternative
solution for this.

Thanks and Regards,
Ravi.
anthony.green
anthony.green
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24540 Visits: 6519
the only way to backup the secondary would be to restore it with recovery so that it comes online for you to back it up. this will terminate the logshipping process and you will need to reconfigure the database again by restoring the database in norecovery mode and then setting up the log backups.

i've never thought about this, but could be open to a lot of interpretation around licencing, as you are going to be executing queries against your secondary, which could break the licencing terms and means you might need to licence your secondary node.

have you thought about your backup routines? considered doing diffs instead of fulls?
also do you have enterprise edition of SQL 2005? Could you not configure backup compression to speed up the backup process?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


ravisamigo
ravisamigo
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1489 Visits: 760
Thanks for your reply.

Will log chain be break/logshipping get failed if we take differential backup of the primary db ?

Thanks and Regards,
Ravi.
anthony.green
anthony.green
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24540 Visits: 6519
no it wont as your not affecting the transaction log



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Bhuvnesh
Bhuvnesh
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13330 Visits: 4077
ravisamigo (3/19/2012)
Hi,

We've SQLServer 2005 logshipping configured on one of production database and the size of this db is around 1 TB. It will take more time to take the backup of the primary database every time.

Not possible to take the backup of secondary database because it is in Restoring phase.

So, please advice how we can take full backup from secondary database or is there any alternative
solution for this.

Thanks and Regards,
Ravi.
logically i dont think you need to have backup of secondary side as primary's database backup will work better and more trust worthy with respect to the data availability.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search