So, as per ur side, we need to restore full backup first then restore all trn log backups up to point of time witch we have required up to..is it...

Use following query:

select r.session_id, r.blocking_session_id, r.database_id, r.command, s.last_request_start_time, s.login_name, r.last_wait_type, r.status

from sys.dm_exec_requests r

join sys.dm_exec_sessions s on r.session_id = s.session_id

where (r.blocking_session_id > 0 and r.blocking_session_id <> r.session_id)

or r.session_id in (select session_id...

SO,as per your side, Mirroring with Sync mode is best..

For my large DBs and Long different location, Mirroring with sync mode is viable?

Yes, we can get high avaibality, but what...

Ease way to find trace is following :

select * from fn_trace_getinfo(0) where value = 5 --

if default trace is running then value is 1 , then we can capture...

have u tried?

Thanks guy,

Can u tell me , my database is fully utilized, around 500 users connected to databases .when transaction occur then the changes write to primary server and how long...

And also find below script which index reorgnize or rebuild depends on fragmentation ratio automatically for perticular database :

SET NOCOUNT ON;

DECLARE @objectid int;

DECLARE @indexid int;

DECLARE @partitioncount bigint;

DECLARE @schemaname nvarchar(130);

DECLARE...

Following script help u to rebuild all indexes of all tables for all databases.

DECLARE @Database VARCHAR(255)

DECLARE @Table VARCHAR(255)

DECLARE @cmd NVARCHAR(500)

DECLARE @fillfactor INT

SET...

My dbsize is 10 GB.In replication all tables(around 1000 tables ) of database will be replicated , it is viable for performaence?

Also check configuration values..

orphun users means users which are exists in database but disassociated with login, we have fix those users in database with logins.

Please run the SQL server upgrade advisor,

and after migration apply run update statistics in all database.

May be dafault trace running :

to stop :

sp_configure 'default trace enabled',0

go

reconfigure

go

Find running trace :

select * from fn_trace_getinfo(0)

Can Transactional Replication solve problem?

Resolve my confusion please..it's important for me.