Viewing 15 posts - 46 through 60 (of 540 total)
Run the following in master to confirm if your cert is bound to your db SELECT DB_NAME(db.database_id) DbName, db.encryption_state,cer.thumbprint,db.key_algorithm,db.key_length
, encryptor_type, cer.name, cer.expiry_date, cer.subject
FROM sys.dm_database_encryption_keys db INNER JOIN...
April 23, 2018 at 2:18 pm
I have a SQL instance configured in logshiping mode
I receive alerts on latencies...
April 2, 2018 at 11:34 am
April 2, 2018 at 9:36 am
March 26, 2018 at 2:46 pm
March 26, 2018 at 12:58 pm
March 26, 2018 at 11:35 am
is any way how to do rights for user, and he will be possible modify...
March 22, 2018 at 1:26 pm
We can remove an old expired certificate the same way it was done for a TDE database outside of an AG from all participating replicas:
USE [master];GODROP CERTIFICATE...
March 8, 2018 at 11:22 am
I have one box, Windows Server 2012 R2 Standard, and the SQL Server 2016 SP1...
March 6, 2018 at 1:42 pm
February 27, 2018 at 2:19 pm
please follow this article
https://www.red-gate.com/simple-talk/sql/backup-and-recovery/sql-server-2014-backup-basics/
February 26, 2018 at 12:03 pm
Mike
Can you post Ola's backup script which you are using?
February 12, 2018 at 2:11 pm
You should setup a local share and have all the scripts saved there instead of UNC.
February 8, 2018 at 10:51 am
Hi Mike
I think you have to specify log directory as well
EXEC dbo.sp_DatabaseRestore
@Database = 'TEST1',
@BackupPathFull = '\\PATHTOFILE\FULL\',
@BackupPathDiff = '\\PATHTOFILE\DIFF\',
@BackupPathLog...
February 7, 2018 at 5:48 pm
Viewing 15 posts - 46 through 60 (of 540 total)