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 12»»

Standby-file location in log-shipping Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 10:53 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 1,865, Visits: 3,620
Is there a query I can use to find the location (path) of the standby file in a log-shipping configuration?

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1354056
Posted Tuesday, September 4, 2012 1:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 6,619, Visits: 14,184
Usually its set to the secondary destination directory which you can get from the following

exec sp_help_log_shipping_secondary_database 'yourdb'



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1354149
Posted Tuesday, September 4, 2012 2:38 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 1,865, Visits: 3,620
Perry Whittle (9/4/2012)
Usually its set to the secondary destination directory which you can get from the following

exec sp_help_log_shipping_secondary_database 'yourdb'



Thanks, I tried that but did not see the information displayed in any of the columns returned;
there is no column named "secondary destination directory" or close to it.

I ran the above command on the standby server.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1354181
Posted Tuesday, September 4, 2012 2:41 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 6,619, Visits: 14,184
the column is called 'backup_destination_directory'

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1354184
Posted Tuesday, September 4, 2012 2:44 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 1,865, Visits: 3,620
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'


That location contains the log backups copied to the standby from the principal. There is no standby file there.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1354191
Posted Tuesday, September 4, 2012 2:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 6,619, Visits: 14,184
Marios Philippopoulos (9/4/2012)
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'


That location contains the log backups copied to the standby from the principal. There is no standby file there.

yes it does and by default will have the TUF file too unless someone has deleted it

When the log shipping plan was created did the wizard backup and restore the database for you or was the database already initialised?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1354192
Posted Wednesday, September 5, 2012 2:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 1,865, Visits: 3,620
Perry Whittle (9/4/2012)
Marios Philippopoulos (9/4/2012)
Perry Whittle (9/4/2012)
the column is called 'backup_destination_directory'


That location contains the log backups copied to the standby from the principal. There is no standby file there.

yes it does and by default will have the TUF file too unless someone has deleted it

When the log shipping plan was created did the wizard backup and restore the database for you or was the database already initialised?


I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.
Is that why it is not showing up?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1354384
Posted Wednesday, September 5, 2012 3:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:13 AM
Points: 6,619, Visits: 14,184
Marios Philippopoulos (9/5/2012)
I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.
Is that why it is not showing up?

So what path\filename did you specify for

WITH STANDBY = 'path\filename'



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1354417
Posted Thursday, September 6, 2012 10:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:24 AM
Points: 1,865, Visits: 3,620
Perry Whittle (9/5/2012)
Marios Philippopoulos (9/5/2012)
I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.
Is that why it is not showing up?

So what path\filename did you specify for

WITH STANDBY = 'path\filename'



It was definitely different (even different LUN) than what is recorded in that column.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1355454
Posted Tuesday, February 25, 2014 5:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 14, 2014 1:58 AM
Points: 47, Visits: 337
I realise that this question was raised a long time ago, but I thought I'd address it.

In my experience the .TUF file is put into the same directory as the database data files. Not the the directory where the transaction log backups are copied to.

Tom
Post #1544852
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse