Viewing 15 posts - 196 through 210 (of 243 total)
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...
November 26, 2008 at 10:46 pm
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...
November 25, 2008 at 10:01 pm
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...
November 25, 2008 at 9:59 pm
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...
November 25, 2008 at 7:17 am
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...
November 24, 2008 at 10:05 pm
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...
November 24, 2008 at 9:55 pm
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...
November 24, 2008 at 9:53 pm
My dbsize is 10 GB.In replication all tables(around 1000 tables ) of database will be replicated , it is viable for performaence?
November 24, 2008 at 6:00 am
orphun users means users which are exists in database but disassociated with login, we have fix those users in database with logins.
November 24, 2008 at 5:55 am
Please run the SQL server upgrade advisor,
and after migration apply run update statistics in all database.
November 24, 2008 at 5:53 am
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)
November 23, 2008 at 9:59 pm
Can Transactional Replication solve problem?
November 23, 2008 at 9:47 pm
Resolve my confusion please..it's important for me.
November 23, 2008 at 9:44 pm
Viewing 15 posts - 196 through 210 (of 243 total)