Viewing 15 posts - 2,716 through 2,730 (of 9,244 total)
Siberian Khatru (11/21/2014)
1. How does switching TDE on affect the backup set(s) for a database?
Once TDE is enabled in the database all backups will be dependant upon the certificate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:28 am
sminar (11/21/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:15 am
plamannkathy (11/21/2014)
USE [master]
RESTORE DATABASE [TESTFULL] FROM DISK = N'TESTFULL_FULL_20141120_190322.bak'
WITH FILE = 1, NORECOVERY,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 8:12 am
charipg (11/21/2014)
we can find free space on disks with 'xp_fixeddrives'.i need script to find all disk size(total size\capacity) in the servers, any help ?
easy via Powershell
Get-Volume | ?{$_.DriveType -EQ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 7:06 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 7:01 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:50 am
would have thought the biggest issue here is that conversion is not allowed from type date to type bit!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:44 am
was this database originally a sql server 2000 database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:00 am
arrjay (11/20/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2014 at 3:45 am
this thread is old!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 2:08 pm
robin.pryor (11/19/2014)
So there's just no way to disable a Windows Group login?
only deny, but be careful here. Please see this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 2:07 pm
windows groups cannot be denied as detailed here
The link states;
MSDN - ALTER LOGIN (Transact-SQL)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 10:48 am
no it's a temporary workspace
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 10:36 am
ramana3327 (11/17/2014)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 5:32 am
rupert.hirst (11/18/2014)
Ok, I'm with you, yes I was missing the specific -d <dbname> parameter, and with this added, it looks to work.
With the -d parameter my connection is to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 8:27 am
Viewing 15 posts - 2,716 through 2,730 (of 9,244 total)