InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:19:50 GMT20http://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Perry Whittle (9/5/2012)[/b][hr][quote][b]Marios Philippopoulos (9/5/2012)[/b][hr]I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.Is that why it is not showing up?[/quote]So what path\filename did you specify for [code="SQL"]WITH STANDBY = 'path\filename'[/code][/quote]It was definitely different (even different LUN) than what is recorded in that column.Thu, 06 Sep 2012 10:08:04 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Marios Philippopoulos (9/5/2012)[/b][hr]I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.Is that why it is not showing up?[/quote]So what path\filename did you specify for [code="SQL"]WITH STANDBY = 'path\filename'[/code]Wed, 05 Sep 2012 03:54:46 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Perry Whittle (9/4/2012)[/b][hr][quote][b]Marios Philippopoulos (9/4/2012)[/b][hr][quote][b]Perry Whittle (9/4/2012)[/b][hr]the column is called 'backup_destination_directory'[/quote]That location contains the log backups copied to the standby from the principal. There is no standby file there.[/quote]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?[/quote]I had initialized it previously using a manual "RESTORE DATABASE ... WITH STANDBY ..." command.Is that why it is not showing up?Wed, 05 Sep 2012 02:46:19 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Marios Philippopoulos (9/4/2012)[/b][hr][quote][b]Perry Whittle (9/4/2012)[/b][hr]the column is called 'backup_destination_directory'[/quote]That location contains the log backups copied to the standby from the principal. There is no standby file there.[/quote]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?Tue, 04 Sep 2012 14:50:01 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Perry Whittle (9/4/2012)[/b][hr]the column is called 'backup_destination_directory'[/quote]That location contains the log backups copied to the standby from the principal. There is no standby file there.Tue, 04 Sep 2012 14:44:54 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspxthe column is called 'backup_destination_directory'Tue, 04 Sep 2012 14:41:20 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspx[quote][b]Perry Whittle (9/4/2012)[/b][hr]Usually its set to the secondary destination directory which you can get from the following[code="SQL"]exec sp_help_log_shipping_secondary_database 'yourdb'[/code][/quote]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.Tue, 04 Sep 2012 14:38:21 GMTMarios Philippopouloshttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspxUsually its set to the secondary destination directory which you can get from the following[code="SQL"]exec sp_help_log_shipping_secondary_database 'yourdb'[/code]Tue, 04 Sep 2012 13:38:15 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1354056-1549-1.aspxIs there a query I can use to find the location (path) of the standby file in a log-shipping configuration?Tue, 04 Sep 2012 10:53:13 GMTMarios Philippopoulos