Viewing 15 posts - 6,901 through 6,915 (of 9,253 total)
not entirely sure what it is you are getting at??
July 15, 2011 at 1:40 pm
never tried this to be honest. What i can say is, an endpoint needs to be created on each instance for database mirroring to be established
July 15, 2011 at 1:34 pm
solomon.jernas (7/15/2011)
Could you give any example for encrypt & decrypt two column in a table ( ssn int, b_date datetime)
I did in the link above 😉
It's a case of RTFM
July 15, 2011 at 5:53 am
it does depend, in certain scenarios the mirror database will stay disconnected in recovery when both machines have restarted and the mirror comes back up first.
July 15, 2011 at 4:34 am
using cell encryption it is possible, there are schema changes to the columns to enable this. The data must be encrypted\decrypted as it is written\read from the table.
This link...
July 15, 2011 at 4:15 am
nalinabey (7/15/2011)
Hi perry,This Link is not working it seems?
try the link above now i have corrected it 😉
July 15, 2011 at 4:09 am
This link details the requirements
It states as follows
Books Online
Creating a new mirror database minimally requires taking a full backup of the principal database and a subsequent log backup and...
July 15, 2011 at 2:45 am
You're welcome
July 14, 2011 at 2:57 pm
Link here 😉
😎
July 14, 2011 at 2:17 pm
This should get you started
SET NOCOUNT ON
--Check if the temp table exists, if it does cleanup!
IF (object_id('tempdb..#sysdbs')) IS NOT NULL
BEGIN
...
July 14, 2011 at 2:10 pm
perfectly ok for the 2 to co exist
July 14, 2011 at 2:01 pm
SQL7 databases may be directly attached\restored to SQL Server 2005 with no step between. When upgrading to SQL Server 2008 you would need to go through either SQL Server 2000...
July 14, 2011 at 1:48 pm
logicinside22 (7/14/2011)
created clusterdc , node1,node2 virtual machine names on VMware.
Allocated 15GB hard drive...
July 14, 2011 at 1:41 pm
Viewing 15 posts - 6,901 through 6,915 (of 9,253 total)