i have fresh new server ,

what i can do it for better performance.

the 1st server has

24 Gb RAm

and 2nd server has

12 Gb RAM.

Thanks Steve and Roy .

i have lots of questions in my mind to ask. 🙂

Please keep me guide as a mentor.

thanks Roy..

i m new in sql server DBA. So please forgive me if i ask stupid question.. 😉

recently we done setup of our new servers, and i have two Production...

Thanks Pradeep , its working. 😀

but it is compulsory to mention the port no in server address, when we access sql server with the deferent port.

sql server in DMZ. so can't ping it, i can only access using a perticuler port,

i checked all the setting in network configure,

i stucked 🙁

please help...

Sql browser service is running...

TITLE: Connect to Server

------------------------------

Cannot connect to 192.168.147.25.

------------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify...

and i m also checked port no by the client machine, it is opened

using telnet command.

A network related or instance specific error occurred .

Thanks 🙂

thanks dev for your valuable inputs .

but i have already installed sql server 2008 with service pack 3 in anther windows server 2008.

now i want to transfer all database...