SQL log

Date 11/28/2012 11:57:32 AM

Log SQL Server (Archive #1 - 11/28/2012 11:57:00 AM)

Source spid56

Message

Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

I want to know what the transactions executed ?

not enough disk space, because HDD more 10GB

miss copy, full path is D:\MSSQL_BACKUP\DB_backup_201201221250.trn

I do not think so

thanks for support

I sent deadlock txt file and xml file

Please review it

See attachment image at

But How to resolve it ?

thanks

I found the object causing daedlock. See attachment image at

But How to resolve it ?

thanks

I ran the script "DBCC TRACEON(1222,-1)" but deadlock still appear

Can resolve finish ?

It still deadlock occur.

can resolve finish ?

thanks for support,

It's very good

thanks for support

I had on SSIS Transfer Logins Task. It also take the users exists on server A.

The users of restored database from server B it doesn't look