If you're using Windows 2008, ensure you get the latest version of SETSPN.EXE which can identify any duplicates which won't usually be visible via ADSIEDIT or ealier versions of SETSPN.EXE.

for future reference there's no need to delete the...

The trick is to set the...

No, you cannot backup an offline database, however you can copy...

if you run the remove node action in the sql server setup the node is removed from the specified clustered instance of sql server, it is not removed from the...

khott (7/3/2013)

---

Here is what I would like to do and wanted to know if possible.

With always on, have one active node for production applications, one node for reporting with different...

Are you referring to the node computernames?

What do you mean DNS names will change?

as long as you have access to a DNS server and a domain controller it shouldn't make any difference to you.

HildaJ (7/1/2013)

---

I have a database that I need to change the dbo owner from user A to user B. I'm getting different errors.

When I try to change it I...

You're carving LUNs from the same set of physical disks, which is not best for performance. Having said that, it depends on how the cache is configured and how good...

Glad you found it helpful 😉

😉

kjtyson05 (6/21/2013)

---

What I had to do was place a dependency on the mount point that the disk arrays that hold "data, backup and tempdb" are online before the mount point...

See my article here[/url] and also the relevant Microsoft KB

I have P2V'd machines that had SAN attached storage no problem in the past. There were issues with earlier versions of VMware converter where it wouldn't see SAN attached drives...