Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Logshipping - Need full backup of Sencondary Database Expand / Collapse
Author
Message
Posted Monday, March 19, 2012 1:43 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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.
Post #1268824
Posted Monday, March 19, 2012 2:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:10 AM
Points: 5,231, Visits: 5,102
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
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

Post #1268832
Posted Monday, March 19, 2012 2:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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.


Post #1268836
Posted Monday, March 19, 2012 2:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:10 AM
Points: 5,231, Visits: 5,102
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
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

Post #1268839
Posted Monday, May 14, 2012 1:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1299386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse