Remote desktop

Standalone or clustered instances?

For standalone you can use precreated INI file configurations and point setup.exe to the INI file.

The other option is to build sql server into your server image...

aplogies, my mistake. Even so if it's TDE the link i posted still applies, it details how to backup and restore the cert to a new server, which is the...

vincent.D_FR (9/3/2014)

---

Hello,

I have a problem that seems to be a bug existing in SQL 2008 R1/R2 http://support.microsoft.com/kb/2300689/en-us ). But I work on SQL 2014, so I don't know what to...

😉

You'll need to check the NTFS permissions...

You have or havent solved it, what did you do to solve it??

jacksonandrew321 (9/23/2014)

---

Hi I follow each and every steps and final output is given below:

USE SQLEmployees

GO

BACKUP CERTIFICATE [MyServer_Cert] TO

FILE = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\MyNewCert.cer'

WITH PRIVATE KEY(

--DECRYPTION BY PASSWORD = 'encryption',

FILE =...

It's good, quite long though, but then you are working at Cmd prompt level. Powershell would be my preference, you can invoke sql cmds just as easily via PS.

If i'm...

Introduce a VM into the existing cluster, this will allow you to retain the physical servers into the config. Once you're happy remove the physical boxes from the cluster

aires (9/22/2014)

---

hello

I wonder if anyone has used these three procedures together?

sp_msforeachdb and sp_msforeachtable and sp_spaceused

EXEC sp_MSForEachDB

@command1 = 'EXEC sp_MSforeachtable [?];',

@command2 = 'EXEC sp_spaceused [?]'

Go

I have about...

Ratheesh.K.Nair (9/22/2014)

---

Hi Experts,

We are getting below error in our secondary replica.

The mirror database, "Financials", has insufficient transaction log data to preserve the log backup chain of the principal database. ...

isnt this the same as this one 😉

http://www.sqlservercentral.com/Forums/Topic1611752-2799-1.aspx

Can you provide more detail on...

So the login "restricted" owns the database "maintain", is this the login you wish to change database access for?

Under sql server 2012, to add a database principal to a role...