Viewing 15 posts - 3,211 through 3,225 (of 9,253 total)
tcronin 95651 (6/26/2014)
June 29, 2014 at 1:54 pm
Can you post a screen shot of the tcpip settings dialog in configuration manager
June 28, 2014 at 5:16 pm
kevinsql7 (6/26/2014)
I am also wondering if all three of these method (backup/restore, detach/attach, & copy database wizard) would automatically perform a database upgrade? For instance, if you are...
June 27, 2014 at 8:02 am
No problem, as i said switch to bulk logged for the rebuild and you wont break the log chain, but the rebuild will still be minimally logged
June 27, 2014 at 3:59 am
jitendra.padhiyar (6/24/2014)
I am able to installed DTC. It was timezone issue. I set correct time zone and it works.
Now I face new issue.. I installed MSSQL Server 2008 R2...
June 26, 2014 at 9:07 am
lilywhites (6/25/2014)
There is a 56GB table with a PK that needs to be rebuilt/dropped-created
I'm assuming you're referring to rebuilding the clustered index that was created on the PK column?
You don't...
June 26, 2014 at 9:03 am
UconnDBA (6/26/2014)
June 26, 2014 at 7:37 am
UconnDBA (6/26/2014)
June 26, 2014 at 7:02 am
GBeezy (6/25/2014)
June 26, 2014 at 4:48 am
Eric Mamet (6/26/2014)
This fixed the problem on my test machine.
I did not have to create an outbound rule on the client windows firewall, though.
However, there are so many rules...
June 26, 2014 at 4:34 am
tommi_j (6/26/2014)
I guess removing the mirroring and then configuring the same setup again could work but this is a critical DB and not easily done.
What's so difficult about it?
June 26, 2014 at 4:31 am
faisalfarouqi (6/26/2014)
Thanks! Perry....but then you're asking me again to migrate the objects which isn't what I want to do. Basically, all I want to do is an in-place upgrade.Regards,
Faisal
There is...
June 26, 2014 at 4:27 am
Also be careful if using cpu affinity in the sql instance . If you apply affinity on the 80 core system and it tries to failover to less cores the...
June 25, 2014 at 2:04 pm
faisalfarouqi (6/25/2014)
Yes...that is absolutely correct. Do you think by any chance this is a possible solution.Regards,
Faisal
No, it's not even remotely possible!!
Here's what you could do (and incidentally what i would...
June 25, 2014 at 2:00 pm
PhilipC (6/18/2014)
I was thinking of...
June 25, 2014 at 8:53 am
Viewing 15 posts - 3,211 through 3,225 (of 9,253 total)