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.

cluster configuration is for server and mirroring is database specific. So failover will be only for a perticular database if you configure mirroring.

have a look of this article

http://www.mssqltips.com/tip.asp?tip=1564