Viewing 15 posts - 6,886 through 6,900 (of 9,241 total)
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
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2011 at 2:45 am
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:57 pm
Your best route are the scripts above!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:55 pm
Viewing 15 posts - 6,886 through 6,900 (of 9,241 total)