Roy

Thank you for the link.

@publisher='MyPubServer',@publisher_db='MyPubDB',@publication='MyPublication',@subscriber='MySubServer',@subscriber_db='MySubDB' shows the error codes correctly.

I tried -SkipErrors in the Distribution , Subscription & Publishing agent run for error codes 2621;2627;20053. That does not seem...

I don't understand this. How do i grant access to master? Does it mean granting access to views under master? If so what views? All views? Sorry, if my question...

Hello Swarndeep

Would you mind telling me where / how to set "Continue on Data Consistency error" option? In Bcp or the Destination agent job; I know of mentioning the Error...

Hello Happycat

Thanks for the information. But the problem is i am not able to grant the privilege to that particular user. Are you aware of any work arounds?

Thanks

Any ideas?

Transactional Replication.

I did get the Distribution Cleanup job to run and remove the directory entries. But why it is making copies in the first place? How do i avoid it?

This is SS2008 and hence Surface Area Configuration is discontinued. However, the same can be achieved by Right Clicking on the Service in the Mgmt Studio and under properties ,...

george sibbald (7/22/2009)

---

I can confirm you cannot do that.

a) you cannot backup a database in recovery mode

b) even if you could the log restores would fail beacuse they would...

I have a primary with log shipping to the standby every 5 mins. I want to backup the Standby one. Recently...

By default it says the database is in restore mode; I did not try using the backup command and will try shortly.

For question # 4 , i meant the DDL changes. Should the DBA carry out the DDL in both the databases involved in replication?

1. Download PowerShell for your platform.

2. Install it as Administrator

3. Set Excution Policy using Set-ExecutionPolicy command (Read on Certificates too)

4. Name your 'shell' scripts with .PS1 extension.

5. Few useful URLS

http://msdn.microsoft.com/en-us/library/cc281954.aspx

http://msdn.microsoft.com/en-us/library/cc281945.aspx

http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyId=DF8ED469-9007-401C-85E7-46649A32D0E0&displaylang=en

You...

>First, why shrink the log? If you load again tomorrow and it grows, what have you accomplished? Nothing.

Upon second thoughts i agree with you. Currently in another Production environment...

Hello

I am in the same boat. I found the following links useful.

Installing Clustered SQL Servers - Outline, Checklists, Document Sheets

http://blogs.mssqltips.com/blogs/ChadBoyd/archive/2008/06/29/installing-clustered-sql-servers-outline-checklists-document-sheets.aspx

Getting Started with SQL Server 2008 Failover Clustering

http://msdn.microsoft.com/en-us/library/ms189134.aspx

Before Installing...