Viewing 15 posts - 6,886 through 6,900 (of 9,244 total)
tobyteel (7/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2011 at 4:52 am
either go into Failover Cluster manager open the group and get the resource parameter from there or from a command prompt use
cluster group "groupname" /prop
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2011 at 4:41 am
just out of interest how large are your transaction log files?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2011 at 4:18 am
What other errors do you see, if any, in the SQL server log around the time as the verify?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2011 at 4:12 am
LAW1143 (7/15/2011)
There are 6 or 7 of them, all in the 25 to 40gb range.Rebuilding the clustered index will hit all non clustered indices.
Generally, no
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 8:53 pm
LAW1143 (7/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 3:46 pm
LAW1143 (7/15/2011)
if I absolutely MUST switch to simple
You dont need to and indeed you shouldn't do either. You can however switch to Bulk Logged recovery for the index build and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 2:06 pm
what recovery model is your database using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 1:55 pm
Hi Gangadhara
check the sql server log, are you seeing any other specific errors there around the time the RESTORE VERIFYONLY runs?
How much memory does your server (not SQL Server but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 1:52 pm
not entirely sure what it is you are getting at??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 4:09 am
Viewing 15 posts - 6,886 through 6,900 (of 9,244 total)