Forum Replies Created
Viewing 15 posts - 1,216 through 1,230 (of 9,244 total)
-
RE: Somewhat urgent issue related to AG
Chitown (6/28/2016)
TheSQLGuru (6/27/2016)
What is the status of the other database? Is it suspect, offline or something like that?All DBs are online and in sync
This was the error in the log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: SQL 2016 install failure with mount points on a VM server
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Mirroring in Powershell script
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: SQL 2016 install failure with mount points on a VM server
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Change Port of a Default Instance
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Clustering with problem database
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...-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: SQL and Symantec
maybe this helps you
https://support.symantec.com/en_US/article.DOC4324.html
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Clustering with problem database
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....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Error Connecting to SQL Server
for the database server name try specifying the name and port number. For example
Server1,1433
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: GRANT CREATE/ALTER/DROP logins and users for users
ratloser99 36160 (6/23/2016)
thank you for your reply. It seems to be a good idea to give them these permissions. I will do so. 🙂Well, actually it's not. Do they really...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Change Port of a Default Instance
RonMexico (6/23/2016)
The suggestion was made to help improve security since, you know, no one has ever been able to access an environment not using port 1433 :laugh:Security is not usually...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: SQL and Symantec
tmmutsetse (6/23/2016)
Good day Experts,I am kindly asking if there is anyone on this forum who works with Symantec on their working environment?
I too used to work for a division...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: GRANT CREATE/ALTER/DROP logins and users for users
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Run a query when the cluster node fails from one node to the other
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
RE: Change Port of a Default Instance
Microsoft do not recommend changing the port on a default instance, leave it at 1433.
Why do you want to change it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1,216 through 1,230 (of 9,244 total)