anthony,

in windows server 2003 Lock pages memory default assigned to Administrator group and option for adding new user is disabled. i guess SQL account user need to add in ...

it worked i removed some old backups from the drive and brought it offline then online.

thanks for the help buddy ... 🙂

its a dedicated server

yeah OPENROWSET works, it requires connection string, it does'nt require linked server to configure, but "ad hoc distributed queries" should be enabled through sp_configure.....

thank you so much

ok thanks a ton for your help 🙂

i believe openrowset still require linked server name to pass.

dirent server name wont work in tht right?

Hmmmm..., Gail thanx for your valuable support... 🙂

joe,

well i was talking about Errorl log, i am not sure about anything deleted, only issue is cluster got rebooted yesterdfay and after that SQL service dint come online for...

Yes Gail anthony suggested, and i started the chapter 4 but dint get time to complete it... :-P:-D

widows server 2003 R2 (64 bit)

SQL serever 2005 SP2 (64 bit)

please let me know steps to set max server memory or min server memory.

one more thing joe, can you tell me the proper steps to reboot veritas cluster server, one of the guy from windows team directly rebooted active machine then he found...

joe,

if suppose some one deleted log when services are offline. then what is the process to make SQL services online again.

john,

then??? lock pages enable permision?? and service restart, not required??

Steps to set max server memory or min server memory?

or as a SQLDBA can i check it any how??