Wednesday, March 28, 2012

Log Shipping Tables

Hello all.
Does log shipping use the tables in msdb normally used by backup, e.g.
backupset, backupfile?
Thanks.Log shipping creates its set of tables in the msdb database of the monitor
server.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Yes, but then there are also specialized objects for the log shipping
information in addition to the normal ones.
Either use SQL EM or the Object Browser in QA to browse through the msdb
objects.
Sincerely,
Anthony Thomas
"David Pendleton" <qnircra@.gpd.arg> wrote in message
news:upK2NYL2EHA.3640@.tk2msftngp13.phx.gbl...
Hello all.
Does log shipping use the tables in msdb normally used by backup, e.g.
backupset, backupfile?
Thanks.

No comments:

Post a Comment