Executed as user: NT AUTHORITY\SYSTEM. ...ercent processed. [SQLSTATE 01000] (Message 3211) 97 percent processed. [SQLSTATE 01000] (Message 3211) Processed 40 pages for database 'BACKUP_xn', file 'BACKUP__xn_Data' on file...

hi ,

Error 3041 severity 16 state 1

BACKUP failed to complete the command BACKUP DATABASE database name WITH DIFFERENTIAL. Check the backup application log for detailed messages.

Thanks,

Lavanya

hi ,

This is for one week backup details ::

SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,

msdb.dbo.backupset.database_name,

msdb.dbo.backupset.backup_start_date,

msdb.dbo.backupset.backup_finish_date,

...

Thanks to all

table name :xyz coulumname is :submitdate datatype is : datetime

Initially submitdate by default is null

i updated the column for 100 orders to '02-02-2012 00.00.000'

update xys set...

table name :xyz coulumname is :submitdate datatype is : datetime

Initially submitdate by default is null

i updated the column for 100 orders to '02-02-2012 00.00.000'

update xys set...

no , i want to change those orders value to null [that column data type is datetime ]

Thanks. You are correct ..I know this antony.

Just i am asking him to check both the files in the same drive or different drive??

The mdf and ldf...

hi ,

1. Check for missing indexes

2. Do you running rebuild index\reorg ,update statistics on weekend?

3.Try to find out which queries taking more cpu time from which application ?

4....

Thanks to all.

We abort the indoubt transaction from MSDTC transaction list . After that i run a checkpoint on that database.

I shrink the LDF file. Now the space...

first find the host which initiated the DTC transaction and see if it is still active on that host, if it is terminate it, if not then kill the UOW.

how...

hi Guys,

Any update on this ...........

when i try to run the query

select * from sysprocesses where spid=-2 we are not seeing any rows .

when i run the below query i found orphaned transaction .

select req_transactionUOW

from master..syslockinfo

where req_spid = -2

now my server is in live ,Directly can i kill that transaction , it will...

by using the below query i am unable to find any queries during the time.

select * from sys.dm_tran_session_transactions.

How can i kill that process . Wintel team can...