Viewing 15 posts - 8,611 through 8,625 (of 9,244 total)
Ahmad Osama (12/21/2008)
Net Stop MSSQLSERVER
cdset path=C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn
sqlservr -m
sqlcmd -Usa -Psql2005 -Q "restore database master from disk='D:\SystemDatabaseBackups\MasterDatabaseBackup' with replace
Net...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 8:02 am
yes, use
NET STOP servicename
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2008 at 12:52 pm
Adi Cohn (12/16/2008)
you'll have to bring it online by running the last restore with recovery option.
or just issue a
restore database [mydatabase] with recovery
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2008 at 11:36 am
GilaMonster (12/19/2008)
Perry Whittle (12/19/2008)
assuming it is released quick enough
Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 20, 2008 at 11:26 am
assuming it is released quick enough
this link explains the pros and cons
http://support.microsoft.com/kb/918483
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:58 am
no, in the DNS snap in right click and add server. You should then see both DNS servers, expand and look at the zone setups
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:44 am
just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt. I prefer to start low and work...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:30 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:24 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 6:24 am
Mani
i would start with 11GB RAM for SQL and the rest for the OS. Monitor the server and check the memory usage\requirements, adjust as necessary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2008 at 2:40 am
firstly have you removed DNS from the terminal server?
have you installed DNS on DC2?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:15 pm
Mani (12/18/2008)
We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP2.
We have 16GB RAM.In Our SQL Server instance sharepoint Application databases are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:11 pm
well, depending on where you read. MSDN states that AWE is only available for 32bit Ent and Dev sql2005. Technet states AWE available for Std, Ent and Dev. This has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 5:09 pm
if you're not sure what it does why use it. What version is your OS and SQL instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 2:18 pm
phew, not a pork chop in sight LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 10:45 am
Viewing 15 posts - 8,611 through 8,625 (of 9,244 total)