Raghavender (11/6/2015)

---

Hi All,

I am trying to attach a database. But I am receiving below error:

Unable to open the physical file "D:\databasepc.mdf". Operating system error 5: "5(Access is denied.)".

I have added...

so nothing to do with permissions then

Barcelona10 (11/5/2015)

---

Hi All,

We are trying to find best HA/DR solution for our (SQL Sever 2008R2 STD )PRD server.We were thinking to go with Database Mirroring or Failover Clustering.But since Mirroring...

tress (11/4/2015)

---

Hi,

Hoping someone can help with this, I am currently having to downgrade my SQL Server in my test environment from Enterprise Edition to Standard Edition. I backed up...

744 (11/4/2015)

---

Hi,

We have a SQL 2014 active passive cluster with 5 instances. When the cluster was installed one of the nodes was a virtual machine. As we started to have...

krypto69 (11/4/2015)

---

Hi,

Just inherited a new VMWare SQL2014 server.

I noticed the max server memory is set to 2147483647 MB. Which I realize now is the default.

I know from the sysadmin...

more detail please

Arestas (11/3/2015)

---

Hello all,

As we all know logins and jobs aren't replicated when using AllwaysOn. What i wanna know is if the "tranfer login taks" will be enough to cover the...

or they just read somewhere that it's a best practice

you're welcome

Are you merely attempting to enable TDE?

jayoub (11/2/2015)

---

A: Run the following to create a certificate:

USE <'database name'>

CREATE CERTIFICATE <'certificate name'>

ENCRYPTION BY PASSWORD = '<'password'>'

FROM...

m_obegi87 (10/9/2015)

---

Dear all,

i am trying to add a node to the cluster failover, and i am running it through the command line,

everything seems fine in the summary and detail logs...

That would be a really good idea 😉

JakDBA (11/1/2015)

---

Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.

follow the link

https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx...

which hypervisor are you using?