Viewing 15 posts - 27,196 through 27,210 (of 39,961 total)
Hey, an agreement with me! Usually I'm the one agreeing.
September 16, 2008 at 2:04 pm
Is this read only data? If so, shared scalable databases can work.
If not, I'd look at database mirroring instead of clustering, less complex.
No real scale out solutions for SQL Server...
September 16, 2008 at 2:02 pm
If you set the instance to use a TCP port, it will use that one (if available when the instance starts). I believe the dynamic assignment is done after the...
September 16, 2008 at 2:00 pm
IF you manually increase tempdb to 200GB or so, does it work?
September 16, 2008 at 1:59 pm
There isn't a good way to do this, but there are ways. You can shell out and use SQLCMD or bcp to pull data out. You can setup an SSIS...
September 16, 2008 at 1:58 pm
If you have Enterprise edition, you can do some filegroup restores and bring on sections of your database, but you'd want to have designed this ahead of time.
September 16, 2008 at 1:54 pm
I make time to read all the time. Often 10 minutes here and there throughout the day, while eating lunch, waiting for kids, etc. I probably get in 30-60 minutes...
September 16, 2008 at 1:53 pm
I don't know, but typically advisors don't require a license.
September 16, 2008 at 1:47 pm
It depends. Do you need every clustered instance to work the same if there is a failover? If so, then 64/3 makes sense. If you assume failovers are rare and...
September 16, 2008 at 1:46 pm
I think you made a mistake there of not restoring when you had one node.
I haven't done this, but I'd be nervous about this. Not sure if there is...
September 16, 2008 at 1:44 pm
I have some friends that do this, HOWEVER, they have each VM on separate physical nodes (blades in this case). You must have separate physical hardware, and separate IO paths...
September 16, 2008 at 1:32 pm
Red Herring from me, though I only did a quick check to be sure it was a fake from my side. If someone created it, I didn't see it in...
September 16, 2008 at 1:08 pm
There is a password policy in SQL Server 2005, and if the host OS supports it, SQL Server can respect that. I thought the SA account was immune, but...
September 16, 2008 at 1:07 pm
Agree with David on this one. Nothing should blow up
September 16, 2008 at 1:03 pm
Viewing 15 posts - 27,196 through 27,210 (of 39,961 total)