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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2011 at 12:18 pm
dan-572483 (1/26/2011)
However, this VM run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"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
Viewing 15 posts - 7,291 through 7,305 (of 9,244 total)