it is working fine now, thanks for all suggestions

i reduced the max memory , need to check the functionality of server

i have enabled awe and now memory consumed by sqlserver.exe is bit reduced, i dont know whether doing this is good idea or not

tcp/ip and named pipes are enabled and firewall option is set to OFF, still im getting same error

then how i can overcome this problem?

64 bit machine, do i need to enable awe on this..?? any suggestion on this?

I got below output after executing the query sent :

OBJECT_NAMEcounter_namecntr_value

SQLServer:Buffer Manager ...

which login is preferred for database mirroring, im trying with domain login but im not able to perform mirroring

while restoring how we can do that on mirror server, we need to copy the backup manually then?

it is showing server is in single user mode

Hi All,

The sql server Agent(MSSQLSERVER) service on local computer started and stopped.Some services automatically stop

if they have no work to do,eg the performance logs and alerts service.

Im getting...

Even t-log carries committed tran and uncommitted tran, but while restoring it restore committed data,(not much concerned of uncommitted data at the time of database crash) is anything particular need...

does log back up contains bot committed and committed tran???

Below error the job is throwing:

Message

Executed as user: . Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is...

Thanks a lot jayanth, it worked fine.