I have not said microsoft have told me i could use the data this way.

The reason i started this thread was beacuse i wanted to find out if it was...

a backup and restore wouldnt work as the BI cubes need updating regularly and the database is 500gb, so would take too long to backup copy and restore.

for the code...

it will initially be used as a development BI reporting accessing data from live, when dev is complete we will change to enterprise

The reason for the LInked server (or replication ) in our case is for a BI and reporting server

thanks

unfortunatly i need a difinitive answer from a microsoft document tlling me if i can or cant either use linked server or replicate to a dev edition of sql2008R2

thanks, do you have any microsoft links which would provide this information?

If the page life expectancy goes down to around 30-60seconds, because of what i believe is a piece of code to extract data from a large database. does that...

i have tried nslookup, it shows that there isnt anything on that ip.

The logs show EventID 1129 'Cluster Network is partitioned' but only suggested resolution is to check network adapters...

If i try to ping the sql instances from the Passive node, i do not get a reply, is this normal? (i get a reply from active node).

I also cannot...

Does anyone know how much this costs? i cant seem to find a price anywhere (UK Price)

Do you need a separate license for a passive node on a cluster?

What about...

Thanks for your replies, it is now installed and working fine.

thanks

We need to shutdown both nodes of our cluster (active/Passive) this weekend for a SAN migration.

for a step by step guide what node do i start with and do i...

I can get that far but, i get the errror when restoring the 2nd transaction log. I thin k i have found out why,

The netbackup backups where running as...

I have been looking at the sysdatabases table and it looks like when a database goes offline the version field changes from 611 to NULL, if it is detached the...

I need to be able to get an email when the Job is successful and and email for each of the failed databases