Hi, Renuka

can u say how u created the job which takes only copy-only backups even i want to know the process.

first give a warning to him not to interrupt in your way the way should be like this u should warn him but he should not take personally but he...

As all mentioned in my view my backup of a database size is 109 Gb approximately takes one hour then around 1 TB will take nearly 22 hours

and then...

thnks 4r the awesome reply

thanks and i vl try this in my pc

sqlserver 2008 R2 same edition, version and service pack level,

"If it is going to be the just backup master and msdb and any other databases, put them on the...

Hi

iam not good at coding but i can suggest a logic

1.create a script through a maintenance plan if it not runs normally

2.goes full backup copy-only

also search for...

as mentioned to u if there is no backup how can we restore and make the database active.some where in u r server any backup is available or not check...

Hi,

I have face this type of issue at the time of dc dr drill but we have backup files with us .

1. try to restore the last latest backup if...

hi,

can you please send the query to find the cpu utiliZation

HI robert & perry

ya ivl follow the link and script also if needed. Before that i want to know one thing where should i execute this script for mapping...

Hi Robert

Ineed one confirmation for the alternative step about removing bcp steps suggested by you for [delete the part about copying logins]

where should i execute this script for...

the query is also in the execution plan out put and application team frequently check

this simple query to check the count ---->> select count(*) from acmt

here by the below execution plan states that it is going for full table scan and taking 79% of table and first table is taking 117mb nearly and second...

select count(*) from acmt

1. if the query is getting slow to execute what should we check in activity monitor other than spid !

2. can we trace any thing in...