|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
22/05/2008, 15h11
|
#1 |
Messages: n/a
Hébergeur: |
Identify that database is enabled for logshipping in sql2k5 sp2
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 |
|
|
22/05/2008, 17h33
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Identify that database is enabled for logshipping in sql2k5 sp2
On May 22, 8:11am, 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 |
|
|
|
23/05/2008, 04h10
|
#3 |
|
Messages: n/a
Hébergeur: |
RE: Identify that database is enabled for logshipping in sql2k5 sp2
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 "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 > |
|
|
|
29/05/2008, 20h06
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: Identify that database is enabled for logshipping in sql2k5 sp2
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 <LinchiShea@discussions.microsoft.com> wrotc: >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 > >"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 >> |
|
|
|
| Outils de la discussion | |
|
|
