Viewing 15 posts - 7,291 through 7,305 (of 9,241 total)
am i correct in saying that you have deleted the model.mdf and model.ldf?
My bad, the only database that can be restored in single user mode is the master database. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2011 at 3:50 am
\binn>sqlservr.exe -c;-m
This is not correct, it should be
\binn>sqlservr.exe -c -m
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2011 at 3:32 am
Hi
The command you need is
sqlservr.exe -c -m
Go to the DOS prompt and change directory to the Binn folder where SQL server is installed and run the command above. once...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2011 at 12:26 am
could you confirm the command you are using to start the sql server instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2011 at 1:29 pm
RajaStyle123 (1/26/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2011 at 9:14 am
NLB may work here, never tried it myself.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2011 at 3:22 pm
CirquedeSQLeil (1/20/2011)
Thanks for the article Perry.
Thank you Jason
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2011 at 2:43 am
Viewing 15 posts - 7,291 through 7,305 (of 9,241 total)