Viewing 15 posts - 3,376 through 3,390 (of 9,253 total)
although the restore job says its successful, check the history of each individual step, there'll be an error message there somewhere 😉
April 11, 2014 at 6:15 am
sheeraz.khan (4/11/2014)
Dear Team,I will really appreciate if you could share the role/requirement of primary and secondary replica under SQL Server 2012 AlwaysOn.
Thanks.
Simple really, for each replica you specify...
April 11, 2014 at 6:13 am
hendrik.wentzel (4/9/2014)
We have a 5TB SQL2005 SP1 Enterprise edition database running on end of life hardware that we need to move to new hardware.
Please see brief details below:
-...
April 10, 2014 at 3:50 pm
Native encryption is only available in SQL Server 2014 onwards, as such there are no encryption details stored in
msdb..backupmediaset
msdb..backupset
April 10, 2014 at 3:41 pm
Jampandu (4/8/2014)
So read-only replica is always sync with primary and we can query on read-only replica at any time.
Provided the AlwaysOn replicas are configured for synchronous commit, they'll be in...
April 10, 2014 at 3:08 pm
Jake Shelton (4/10/2014)
if memory serves, without the 2K5 step, the hashing will fail as it has changed base algorithm between 2000 and 2005.
Step not required. The algorithm between 2008 and...
April 10, 2014 at 1:32 pm
Jake Shelton (4/10/2014)
My question is whether I need to move the logins to a 2k5 box as an interim step before relocating again to 2008.
No you don't and...
April 10, 2014 at 6:14 am
defyant_2004 (4/8/2014)
April 9, 2014 at 3:01 pm
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...
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 ===='...
April 9, 2014 at 2:54 pm
is the schedule enabled?
April 9, 2014 at 2:48 pm
sourav_1002001 (4/9/2014)
"Cannot show requested dialog.
Additional information:
Cannot show...
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...
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...
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...
April 9, 2014 at 5:40 am
Viewing 15 posts - 3,376 through 3,390 (of 9,253 total)