ffarouqi (6/29/2016)

---

Hello everyone,

A couple of days ago I was tasked to do a P2V migration from let's say A to B...everything looked fine post migration. I took all the possible...

Chitown (6/28/2016)

---

All DBs are online and in sync

This was the error in the log...

I've just completed a sql 2016 install using 2 mounted volumes, no issue.

Can you post details of the data directories tab on your installation.

as a test create a credential with your account and add it as a proxy then assign proxt=y to the job and run it

Hi Keith

mount points are fully supported in sql server from 2005 onwards for both cluster and standalone usage.

Is this a cluster install or standalone

I cant find the article, As far as I recall a default instance does not support dynamic ports, it is possible to use a static port other than 1433 but...

mart 13485 (6/23/2016)

---

Thanks for the responses. We had to restart SQL Server, affecting all databases, because one of the tables had a lock on it that we were unable...

maybe this helps you

https://support.symantec.com/en_US/article.DOC4324.html

what is the issue with the database, what information is in the logs?

You could stand up a new failover cluster instance in the existing cluster and move the database there....

for the database server name try specifying the name and port number. For example

Server1,1433

Well, actually it's not. Do they really...

Security is not usually...

I too used to work for a division...

ratloser99 36160 (6/21/2016)

---

Some of our keyusers should get permision to CREATE, ALTER and DROP logins and users for specified databases.

I tried

GRANT EXECUTE ON [sys].sp_addlogin TO [keyusers]

GRANT EXECUTE ON...

sunny.tjk (6/20/2016)

---

I'd like to run a query when the cluster node fails from node one node to the other.

Can someone help me achieve this?

I somehow feel looking through the errorlog...