August 30, 2008 02:19am pdt

1. chapmandew 2,035,326
2. angelIII 1,369,238
3. aneeshatti... 513,981
4. mark_wills 473,116
5. ee_rlee 313,995
6. brejk 226,005
7. dtodd 209,505
8. momi_sa... 177,049
9. acperkins 173,863
10. rickchild 167,940
11. ptjcb 160,219
12. Thomasian 155,142
13. EugeneZ 143,750
14. BrandonG... 143,655
15. sbagireddi 136,982
16. dportas 125,215
17. ScottPletc... 123,615
18. jgv 115,921
19. appari 114,604
20. PFrog 113,160
21. DanielWilson 106,114
22. chrismc 105,889
23. PedroCGD 104,345
24. tedbilly 103,765
25. bashka_... 98,724

1. angelIII 2,649,429
2. chapmandew 2,035,326
3. aneeshatti... 1,079,086
4. ptjcb 525,611
5. Yveau 517,373
6. mark_wills 473,116
7. dtodd 420,510
8. PFrog 383,188
9. dqmq 368,078
10. appari 350,751
11. imitchie 333,350
12. ee_rlee 313,995
13. acperkins 269,202
14. ScottPletc... 227,282
15. brejk 226,005
16. Lowfatsp... 223,289
17. matthews... 203,352
18. rboyd56 196,590
19. SQL_SE... 190,215
20. EugeneZ 180,459
21. momi_sa... 178,749
22. gbshahaq 177,810
23. tedbilly 172,104
24. DanielWilson 171,904
25. dportas 169,180

07.09.2008 at 09:40AM PDT, ID: 23550925 | Points: 50

	[x] Attachment Details

Is there any to find whether a database logshipping is enabled or not by using a T-sql query or vbscript?

Asked by vvkp in SQL Server 2005

Tags: Microsoft, SQL Server, 2005 with sp2

Is there any to find whether a database logshipping is enabled or not by using a T-sql query or vbscript?

For expample we can find the status or recoverymodel etc., by using the query
SELECT name, DATABASEPROPERTYEX(name, 'Status')
FROM master.dbo.sysdatabases
ORDER BY 1

like that can we kow about the TransactionLogShipping is enabled or not?Start Free Trial

Keywords: Is there any to find whether a databas…

	Title
1	LOGSHIPPING
2	Finding The LogShipping Databases Usi…
3	sorting with vbscript
4	Need help with VBscript and SQL?
5	Logshipping in SQL Server 2000 St…
6	VBscript SQL Sum Query?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628