Google Groups Home
Help | Sign in
microsoft.public.sqlserver.server
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Identify that database is enabled for logshipping in sql2k5 sp2
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
Peter Lindberg  
View profile
  More options May 22, 9:11 am
Newsgroups: microsoft.public.sqlserver.server
From: plT...@AWAYlg.se (Peter Lindberg)
Date: Thu, 22 May 2008 13:11:35 GMT
Local: Thurs, May 22 2008 9:11 am
Subject: Identify that database is enabled for logshipping in sql2k5 sp2
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
Is there a way to query any dynamic view or system table to see if a
database has log shipping enabled? I belived it should be in
databaseproperty or databasepropertyex but I can'tr find it.

My purpose is to handle these databases in a different way when
building up dynamic transaction log backup job.

/Peter


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
KenJ  
View profile
  More options May 22, 11:33 am
Newsgroups: microsoft.public.sqlserver.server
From: KenJ <kenjohn...@hotmail.com>
Date: Thu, 22 May 2008 08:33:03 -0700 (PDT)
Local: Thurs, May 22 2008 11:33 am
Subject: Re: Identify that database is enabled for logshipping in sql2k5 sp2
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
On May 22, 8:11 am, plT...@AWAYlg.se (Peter Lindberg) wrote:

> Is there a way to query any dynamic view or system table to see if a
> database has log shipping enabled? I belived it should be in
> databaseproperty or databasepropertyex but I can'tr find it.

> My purpose is to handle these databases in a different way when
> building up dynamic transaction log backup job.

> /Peter

Hi Peter,

Books Online has a good list in the "Log Shipping Tables and Stored
Procedures" topic:
http://msdn.microsoft.com/en-us/library/ms175106.aspx

The table log_shipping_primary_databases should have what you're
after.

KenJ


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Linchi Shea  
View profile
  More options May 22, 10:10 pm
Newsgroups: microsoft.public.sqlserver.server
From: Linchi Shea <LinchiS...@discussions.microsoft.com>
Date: Thu, 22 May 2008 19:10:02 -0700
Local: Thurs, May 22 2008 10:10 pm
Subject: RE: Identify that database is enabled for logshipping in sql2k5 sp2
Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
There are so many different ways to set up log shipping. You need to describe
how your log shipping is set up before any suggestion on how to identify it
can be made.

Linchi


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Peter Lindberg  
View profile
  More options May 29, 2:06 pm
Newsgroups: microsoft.public.sqlserver.server
From: peter.lindbergT...@AWAYmartinsson.se (Peter Lindberg)
Date: Thu, 29 May 2008 18:06:38 GMT
Local: Thurs, May 29 2008 2:06 pm
Subject: Re: Identify that database is enabled for logshipping in sql2k5 sp2
Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author
It's set up using books online topic "How to: Enable Log Shipping (SQL
Server Management Studio) ". I totally missed those tables and procs.
I'll take a look into them.

/Peter

On Thu, 22 May 2008 19:10:02 -0700, Linchi Shea
<LinchiS...@discussions.microsoft.com> wrotc:


    Reply    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google