Viewing 15 posts - 1,321 through 1,335 (of 9,244 total)
yan-160997 (3/15/2016)
Well, contacted Microsoft, and ran portqueryUi, it was found that UDP port was blocked inside the server.
Now the question is how can we know where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2016 at 3:08 pm
all partners should the same version of SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2016 at 2:58 pm
george sibbald (3/9/2016)
thanks as always Perry.I presume if you decide to segregate the traffic after initial set up you can do this by use of the alter endpoint command?
either alter...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2016 at 10:59 am
Harshana-455711 (3/11/2016)
We need to move MS SQL Cluster to Standalone SQL Server, what are the steps we need to follow & how to move same instance name with virtual name....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2016 at 5:35 pm
Jon.Morisi (3/10/2016)
USE master
ALTER DATABASE [database] SET PARTNER FAILOVER;
GO
You cannot failover normally as the principal is lost\offline, with a synch session no witness and failed principal you have to use
USE master
ALTER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2016 at 10:44 am
WHug (3/1/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2016 at 6:30 am
you do not need to restore the DMK or even open it to restore a TDE protected database to another server!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2016 at 6:21 am
SQL-DBA-01 (3/4/2016)
$password = read-host -prompt "Enter your Password"
$secure = ConvertTo-SecureString $password -force -asPlainText
$secure
$bytes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2016 at 5:37 am
tony28 (3/5/2016)
I did backup and restored to test..
bak file has about 13GB.
database has allocated mdf file for 40GB and log file for 5GB... I wanted shrink this mdf, because there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2016 at 4:59 am
mrjae (3/6/2016)
I am new to sql server and i am practicing on SQL Express. I have created a table and in error I have duplicated rows. My first...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2016 at 4:58 am
SQL!$@w$0ME (3/3/2016)
Can we use one server certificate(master db) to encrypt multiple dbs in the instance. Or should we create multiple certificates for each TDE db. If so any impact...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2016 at 6:34 am
Jon-183221 (3/1/2016)
Could they not then just go and connect via Excel/Access or anything else?
Yes and you can also roll those back too 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2016 at 6:32 am
can you post the history from the job?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2016 at 9:13 am
VastSQL (3/1/2016)
We have a SQL Server and application uses login 'demo' to connect to DB which is having db_owner privilege. Developers can read the config file and they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2016 at 9:09 am
monamym (2/28/2016)
I have a question , imagine a server that we didn't implement it as standard and now we want to move it's file to other drives to make...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2016 at 3:58 am
Viewing 15 posts - 1,321 through 1,335 (of 9,244 total)