The script is calling xp_fixeddrives which does not support mounted volumes. The disk space can be easily retrieved by either a Powershell query or a WMI query instead of ole...

yan-160997 (3/15/2016)

---

Thanks, Jon.

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...

all partners should the same version of SQL server

either alter...

Harshana-455711 (3/11/2016)

---

Hi

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....

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...

WHug (3/1/2016)

---

I have a SQL Server mirror with no witness with TCP. Connections are configured to use certificates. The IP address of the Principal Partner is changing; the...

you do not need to restore the DMK or even open it to restore a TDE protected database to another server!

SQL-DBA-01 (3/4/2016)

---

Even could not able to pass it properly to the connection string using $bytes and username too.

$password = read-host -prompt "Enter your Password"

$secure = ConvertTo-SecureString $password -force -asPlainText

$secure

$bytes...

tony28 (3/5/2016)

---

Hello,

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...

mrjae (3/6/2016)

---

Hi there,

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...

SQL!$@w$0ME (3/3/2016)

---

Thanks Kevin.

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...

Yes and you can also roll those back too 😉

can you post the history from the job?

VastSQL (3/1/2016)

---

Hi Experts,

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...