IT is logshipping with clustering after switch over we use this script to logins

--------------------------------------------------------

EXEC sp_change_users_login 'report'

EXEC sp_change_users_login 'auto_fix',users

--------------------------------------------------------

if then logins will move from DC to DR after that '2'...

Thanks for ur kind reply

1. same like that it is configured by my senior i did'nt remembert exactly

2. but in the DC DR drill application team trying to...

will this work out ?

1. I'mean suppose a DR is configured newly for first time and then all databases are copied through logshipping

2. At that time will ur...

HI ,

check the virtual memory in ur server in manage and as per the microsoft reccommendations 16 processors sholud be run in 24gb ram this will increase the perfromance of...

HI,

as u said earlier the logs are not restored for one database sothat the LSAlert job failed in both primary and secondary

i have checkd the same and reconfigured...

Hi,

I did not set any force disconnect of database or users actualy iam practicing DC - DR drill(switch over and switch back ) in my laptop to gain knowledge

In...

HI,

As u mentioned i checkd the logs in sqlserver and event viewer

even after all jobs are executed success fully i got this mesage

the error message is :...

HI, Anthony

Its 5mins for each

1. same issue came early for two database at that time i performed manaul Full backup using GUI and restore in secondary with (leave the...

HI mahesh try to use

SELECT

j.job_id AS 'JobId',

name AS 'JobName',

start_execution_date AS 'StartTime',

stop_execution_date AS 'StopTime',

avgruntimeonsucceed,

DATEDIFF(s,start_execution_date,GETDATE()) AS 'CurrentRunTime',

CASE WHEN stop_execution_date IS NULL THEN

DATEDIFF(ss,start_execution_date,stop_execution_date) ELSE 0 END 'ActualRunTime',

CASE

WHEN stop_execution_date IS...

Thank you for reply

Thanks & Regards

Naga.Rohitkumar

1. What about restoring the old backup from tape or server will u tried this ? may be it v'l work !

2. Dont u have a dr for the server...

HI

FIRST OF ALL LET U KNOW ABOUT THIS SCRIPT IS FOR MONTHLY ANALYSIS

SO U DO UR NEED FULL ACCORDINGLY

Fisrt u run the below any of the script depens upon...

HI,

please excuse if any wrong suggestions

In my environment in[banking domain ] which my application is running with [.net and sql server 2005 ]

1. in my deep monitoring from 9...

I Have to Make action plan for future growth of ABC database and drive requirement for next 12 month. Action plan should be very clear and correct.Objective should be as...

I have to do my self but what is the process if a new drive is allocated for backups and datafiles how to move datafiles and backups into new drive...