Yes, I'm talking about periodic Cluster and SQL Service Account pwd Change (Domain account).

I couldnt see any other specific logs in the Eventlog except the above.

If it is Kerberos issue, how can i enable/disable it in Windows Server 2008 cluster administrator.

I already (same...

Answer for Williams Question.

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

The NT user(ABC\Krishjay) is one of the DBA, he is member of ABC\DBOps_Team (Domain Admin group) which is member of local administrator group of this box and...

Is there possibly an explicit deny on a group the user is a member of? And have you ensured that the user logon is enabled, not just added to the...

OK, here is the issue, I found that the Disk where the primary data file placed has some issue.

Event Log

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

"The file system structure on the disk is corrupt and unusable....

The CHECKDB executed and there is no consistency errors on the DB.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Database1'.

DBCC execution completed. If DBCC printed error messages,...

Thanks for your suggesstions, this is new database, we didnt do so far, i've to schedule it in off bussiness.

Im restoring with STANDBY option for new logshipping setup.

Also I found the following in the SQL log, looks like some consistency issue in page level

2008-11-04 16:08:24.350 spid74 ...

Anybody resolved this issue? Im also facing this issue.

Thanks

Jay.

If I understood your problem exactly, following is the solution,

if you are able to connect the server thru IP address but not with name of the server means you can...

Thanks for your update.

Are there any possibilities to resolve this issue without using group mail box?

Thanks in advance...

Jay.

I also getting this when I'm calling an .sql file thru SQLCMD, that particular SPID shows NOP some time and INSERT as well after. Im getting exact clue on this....

Hope sys.dm_exec_requests is dynamic management view featured from SQL 2005 onwards :hehe:

I couldnt understand your requirement clearly, do you want to split the SQL native backup for a database into different files, if so below is the example.

backup database master to...

yes, Add the stats clause in the RESTORE command and check the DBCC OUTPUTBUFFER(spid) of the specific restore spid, you can see the percentage of completion.