ah see it now.

is BUILDSERVER the correct instance name?

restart the instance and login through SSMS and open a new query window then run

select @@servername

it should be possible to dump the RESTORE FILELISTONLY to a temp table and then build a restore command from the data in that temp table

yeah, you'd expect a named instance to have a unique servicename

Ahmad Osama (12/21/2008)

---

I am using these batch commands to restore master database......

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...

yes, use

NET STOP servicename

or just issue a

restore database [mydatabase] with recovery

GilaMonster (12/19/2008)

---

Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim,...

assuming it is released quick enough

this link explains the pros and cons

http://support.microsoft.com/kb/918483

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

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...

open the DNS snap in and add each of the DNS servers in then check the zone configs

open the DNS snap in and add each of the DNS servers in then check the zone configs

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

firstly have you removed DNS from the terminal server?

have you installed DNS on DC2?