You can use Replication and mirroring at the same time, you should use a remote distributor for the replication.

Microsoft have a guide for setting this up;

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

christof_c (6/2/2009)

---

Christopher,

removing the webref had no effect - here is my output.

MultipleID Date Region Category Description Web Views Offers Made Broker Interest ...

You have xsh.webref in the group by and as a count in the select statement, try removing this from the Group By to see if this gives you the...

rambilla4 (5/30/2009)

---

thank you,

Iam restoring from the local drive only.

In Server A (Development Server), is taking 20 mins, which is a Virtual server having Backfile and datafiles on same drive...

phumlo1 (6/1/2009)

---

The way they want it to happen is, they will forward me a File with changes from the Master DB and. I would then be expected to import that...

With different tables then it will be difficult to setup replication (as far as i am aware) You may...

phumlo1 (6/1/2009)

---

Hi All,

Thanks for all the responses so far. The secondary BD is actually a CRM system. they will use info from it for all correspondence with their customers. So...

What is purpose of the secondary database?

If it is for High-Availabilty then you can use database mirroring,

but if it is for reporting then you will not be able...

This is quite a large topic and the approach that you take depends on a lot of factors.

Fortunately Microsoft has provided a lot of walkthroughs that will be able to...

My suggestion would be to have a look at the ETL process and see if there are ways you can re-write it to be more efficent.

What does the process...

does that file exist in that path? and can the pc you are using access it?

At a guess, the network path in your statement is incorrect.

check that the following network paths and files exist.

"\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage.dtsx"

" "\\10.207.112.70\D:\QA\Packages_27April\Deployment_Folder\CopyParameters\CopyPackage_Config.dtsConfig"

I haev to agree with the advice about learning the Kimball method for data warehousing, grab a copy of this book..

http://www.amazon.com/Data-Warehouse-Lifecycle-Toolkit-Developing/dp/0471255475

That is what Gianluca Sartori posted earlier on in the first page, ...

Post the Stored procedure that you are calling as it is difficult to know what the problem is without seeing it.