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

Backup log shipping target database? Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 6:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:31 AM
Points: 79, Visits: 430
On a log shipped database, my client wants to be able to backup the target database as well as the source.

Is this possible?

Thanks.

SQL2K5 & 2008.
Post #1472083
Posted Wednesday, July 10, 2013 7:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:45 AM
Points: 1,058, Visits: 2,696
On source it is possible but i fear not possible in target server as it will be restoration mode.

why does he want that?



Regards
Durai Nagarajan
Post #1472105
Posted Wednesday, July 10, 2013 7:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:31 AM
Points: 79, Visits: 430
Thanks, grateful for confirmation.

He wants to do it because my client is a busy fool throwing out poorly thought out "solutions" to requirements he hasn't properly analyzed or explained. It's hard to explain the environment & politics I currently work under. It forces me to ask lots of stupid questions on this forum.

I am much obliged!

Post #1472141
Posted Thursday, July 11, 2013 11:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 1:32 AM
Points: 170, Visits: 740
Hello,

In logshipping,Generally you can take the full backup of Source Database and But in Target Server is not possible to take the full backup,As you know already Restoring means the database is not accessible. Standby means it is read-only( but users can query it – except when a log backup is being restored.)
But full back up is not possible in Target Server Database.


Please check the below link

http://www.sqlservercentral.com/Forums/Topic1268824-361-1.aspx#bm1299386

Thanks®ards,
DBA


SQL server DBA
Post #1472862
Posted Friday, July 12, 2013 2:44 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:31 AM
Points: 79, Visits: 430
Thanks for the reply.

As usual around here, it's not been thought through at all. :).

Cheers.
Post #1472906
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse