like i suggested you earlier, your log restoration sequence will be broken on secondary till you not restore your latest full or differential backup and then onwards log backup

is facilities always 1? What type of field is storing value '1' or '15'? Is it int or varchar?

if they...

try this :-

DECLARE @sqltext VARBINARY(128)

SELECT @sqltext = sql_handle

FROM sys.sysprocesses

WHERE spid = 'your spid'

SELECT TEXT

FROM sys.dm_exec_sql_text(@sqltext)

GO

the length you can modify further

dbcc inputbffer(spid)

which version of sql you installed?

that is the copy only option and yes its from 2005 onwards.

But you can take the...

you can use any test database to first understand the basic architecture of database and can also familiarise yourself with sql queries.

Then you can proceed further with backup/restore sequence.

Have a...

thanks steve, I already did that. Actually I restored all logs and then last log with recovery assuming that might be this time the record get deleted. But I was...

thanks Gail.

Yes, now I am going to take the backup of till now restored database and then will restore it with no recovery and then further logs..

yes it will be automatically refreshed on secondary but it depeneds on how frequently you refreshing you secondary by log backup of primary..

then i think. like i suggested earlier, you need to run the trace to capture the deadlock event using profiler, if that is possible.

you can run the profiler to capture the deadlock event and deadlock graph for better clearity.

Just run the profile with only deadlock event and deadlock graph for specific database and...

i dont have much idea on coding so just tried to search for this issue and found this article

http://www.go4answers.com/Example/database-mirroring-asp-application-13913.aspx

hope it will answer your question.

Also you can schedule the job which will copy your backups regulary to some safe place and can be used in time of recovery.