Viewing 15 posts - 7,306 through 7,320 (of 9,253 total)
could you confirm the command you are using to start the sql server instance?
January 27, 2011 at 11:24 am
you need to have properly configured SPNs to be able to use Kerberos, connections that fail via kerberos or are unable to use it will default to NTLM. Ferguson's query...
January 27, 2011 at 7:06 am
I regularly use VMWare for clustering Windows 2008 and SQL Server. You will need to get a handle on the performance requirements as not every system is suitable for virtualisation....
January 27, 2011 at 2:38 am
George Sibbald
If the external site is your company and the DR node will only ever be active when the primary is down you would not need to license it.
This is...
January 26, 2011 at 5:13 pm
domain authentication would be out here, so a local user on each of the SQL Servers with matching passwords should cover the access to the shares on each machine for...
January 26, 2011 at 1:29 pm
RajaStyle123 (1/26/2011)
January 26, 2011 at 1:25 pm
jasonmorris (1/24/2011)
Fell foul of this one ourselves and ended up deciding to set the directory paths to be identical so we don't get caught again in the future.
It can be...
January 24, 2011 at 9:14 am
NLB may work here, never tried it myself.
January 24, 2011 at 9:11 am
S.K. (1/23/2011)
I believe Perry is steering you in the way of choosing to add a new instance, don't "add features" to the existing installation.
correct, that is exactly what I am...
January 23, 2011 at 11:58 pm
Alex
i tested this on my mirror setup, adding the filegroup itself was fine. After adding the filegroup FG1, I failed over the principal (the mirror is now principal) and when...
January 22, 2011 at 1:38 pm
adrian.saunders (1/21/2011)
Established Cluster
OS windows 2003 64 bit sp2
Node 1 installed with sql 2000 32bit enter sp4, sql2005 64 bit ent sp3
Node...
January 21, 2011 at 3:22 pm
CirquedeSQLeil (1/20/2011)
Thanks for the article Perry.
Thank you Jason
January 21, 2011 at 2:43 am
Chris Mathews (1/20/2011)
January 21, 2011 at 2:42 am
Once you have the backup file you want to restore perform a filelistonly restore to get the filenames and logical names. Use these to restore the database.
January 20, 2011 at 3:04 pm
my guess is your trace create script looks like this
sp_trace_create @TraceID output, 0, N'InsertFileNameHere', @maxfilesize, NULL
It hits the max file size but does not rollover, it should look like this
sp_trace_create...
January 20, 2011 at 4:52 am
Viewing 15 posts - 7,306 through 7,320 (of 9,253 total)