Not if this completed successfully

USE [master]

ALTER...

Once TDE is enabled in the database all backups will be dependant upon the certificate...

sminar (11/21/2014)

---

Can anyone point me to a simple summary of the new backup encryption? I've found a small handful of articles, but apparently I have some sort of mental block...

plamannkathy (11/21/2014)

---

--Step 2 in the full recovery model restore is to restore the last full backup

USE [master]

RESTORE DATABASE [TESTFULL] FROM DISK = N'TESTFULL_FULL_20141120_190322.bak'

WITH FILE = 1, NORECOVERY,...

easy via Powershell

Get-Volume | ?{$_.DriveType -EQ...

This should be the database engine url not the mirror endpoint as you have specified

READ_ONLY_ROUTING_URL = N'TCP://SQL01.contoso.local:5022'));

So, as an example, if i set my sql server instance called bob on...

The ReadOnly routing URL setup is a manul process via PowerShell or TSQL, your readonly routing url and your mirror endpoint urls are the same, this is incorrect! Refer back...

would have thought the biggest issue here is that conversion is not allowed from type date to type bit!

was this database originally a sql server 2000 database?

arrjay (11/20/2014)

---

We performed several tests on the disk and found that it was performing as expected. We then monitgored the time it took for information to be pass between...

this thread is old!

only deny, but be careful here. Please see this link

windows groups cannot be denied as detailed here

The link states;

MSDN - ALTER LOGIN (Transact-SQL)

---

You cannot use ALTER_LOGIN with the DISABLE argument to deny access to a Windows group. For example,...

no it's a temporary workspace

ramana3327 (11/17/2014)

---

Hi,

I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and...