You'll need to ensure any ports are open and also, since the servername SERVER=xxx.xx.xx.xxx won't exist or be resolvable, when creating the linked server change this code portion

@datasrc='SERVER=xxx.xx.xx.xxx'

To this

@datasrc='xxx.xxx.xxx.xxx'

or this

@datasrc='myservername'

deep_kkumar (6/13/2012)

---

backup job and copy job working fine. But there's a huge delay in restore job.

If the retention period is set to 12 hrs on the copied files. If...

I work with Oracle and SQL server databases, the biggest unknown usually comes when the Oracle instance is running on Unix. Unix servers can be difficult to master and that...

OLDCHAPPY (6/15/2012)

---

a vendor has implemented a change to their db structure to split the database (700GB) into multiple datafiles (8) which we have now placed on 2 separate SAN disks...

based on this......

SQLSACT (6/12/2012)

---

This is where we are

Forget about Server3 - Doesn't exist

We have a 2 Node Cluster with servers Server1 & Server2

In a different geographic location (on the same...

In my opinion you would probably be better off with subversion?

One option might be to use either Veritas Cluster Server or HP Polyserve.

Above that you can, if using Enterprise or Datacenter editions, use scale out deployments where multiple web front...

k.subramanyam1017 (6/12/2012)

---

Hi friends,

I have alredy installed sqlserver in 'c' drive but i want to change the 'd' drive. is it possible or not pls...

APA0876 (6/11/2012)

---

Hi,

SQL Server 2008 R2 Failover Cluster, Which windows server roles are recommended and which ones not recommended to be installed?

I'm asking because both of the servers of my...

sorry still not with you

Sorry, I'm really confused about this, you said originally you wanted to retain server2 so why on earth would you request the below!

SQLSACT (6/12/2012)

---

Can I swap Server1 with Server2 in...

SQLSACT (6/12/2012)

---

A question regarding this part:

You'll need to uninstall any clustered instances from server1 so that they are only available on server2. Once this is done you then evict server1...

They don't at all. Share permissions and NTFS permissions are completely separate but do combine when accessing objects through a share,...

the same .NET code has methods for reading and writing images as LOBs into the database

SQLSACT (6/12/2012)[hrYep

All Servers are in the same domain

However, Server3 has its' own storage

Basically, what I want to achieve is:

Currently Server1 & Server2 are together in a 2 node cluster...