Viewing 15 posts - 3,376 through 3,390 (of 9,241 total)
The database is encrypted a page at a time and on a large database can take some time. The database is still available for normal access, however maintenance is disabled...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:56 pm
Try this
SET NOCOUNT ON
DECLARE @sql NVARCHAR(MAX)
SET @sql = ''
SELECT @sql =
'--======================================================================================' + CHAR(10) +
'--==== IMPORTANT: Before executing these scripts check the details to ensure they ===='...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:54 pm
is the schedule enabled?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:48 pm
sourav_1002001 (4/9/2014)
"Cannot show requested dialog.
Additional information:
Cannot show...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:38 pm
as detailed here
Transparent Data Encryption
The following operations are not allowed during initial database encryption, key change, or database decryption:
•Dropping a file from a filegroup in the database
•Dropping the database
•Taking the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:35 pm
The filestream group is just create on a location on an NTFS volume, there's no reason why you can't use mounted volumes. Have a read through this[/url] for info on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 2:24 pm
Jake Shelton (4/9/2014)
Is this feasible via the SSIS Transfer Logins task?? I've read a lot of articles talking about doing this scriptually instead, now I'd far rather have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 5:40 am
The login Amtpl is already mapped to a different database user. Use the following to identify the logins current database user account
use [yourdb]
selectd.name as DBUsername
, s.name as Loginname
from sys.database_principals d
inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2014 at 5:34 am
No, the cluster service should be left as is. The issue is because the Cluster Name object does not have permission to create Virtual Computer Objects. Either pre stage them...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 9:20 am
dajonx (4/7/2014)
- The cluster identity '2012CLUSTER$' has Create Computer Objects permissions. By default all computer objects are created in the same container...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 5:30 am
free_mascot (4/6/2014)
From the security and connectivity perspective it would be good to keep sql servers on domain.
Not necessarily, security can still be implemented effectively on workgroup computers, it's just harder...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2014 at 5:24 am
DKG-967908 (4/7/2014)
1. But what the Microsoft best practice says about this.
2. If we consider from security point of view - SQL server should be on domain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2014 at 9:48 am
Joining a server to a windows domain provides centralisation of uses and resources.
Computers in a workgroup require users and objects to be maintained locally on each machine. When providing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2014 at 2:33 pm
what size did you shrink the file too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2014 at 4:51 am
PHXHoward (4/3/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2014 at 5:28 am
Viewing 15 posts - 3,376 through 3,390 (of 9,241 total)