Viewing 15 posts - 7,291 through 7,305 (of 9,244 total)
SQL Dude-467553 (1/28/2011)
By default a new install adds local admins as sysadmins in SQL Server
Not in SQL Server 2008 it doesn't!
Vadon, during the installation you would have run through the...
January 29, 2011 at 12:18 pm
dan-572483 (1/26/2011)
However, this VM run...
January 28, 2011 at 8:15 am
when sql server is in single user mode you can only restore the master database!
single user mode is initiated by the following commands
sqlservr -m
sqlservr -f -T3608
Copy the tempdb files to...
January 28, 2011 at 4:18 am
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...
January 28, 2011 at 3:50 am
\binn>sqlservr.exe -c;-m
This is not correct, it should be
\binn>sqlservr.exe -c -m
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...
January 28, 2011 at 12:26 am
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
Viewing 15 posts - 7,291 through 7,305 (of 9,244 total)