apply latest patch on client . not engine but client.

seems like its sql 2005.

Yes one job for ----primary ---backup L

two jobs for secondary --standby ---copy L and restore L

make sure you choose different server name when...

READ book or BOL. it is explained in details there.

sql does not audit dml unless you setup trace. and why you think some command will change password for login .

run this and see create data and update column. it...

if its sql 2005 then use snapshot of database before making any change.

if change is not good or wrong just restore that snapshot. its very fast since it only restore...

here you go for sql 2005

select * from msdb..restorehistory

order by restore_date

here you go for sql 2005

select * from msdb..restorehistory

order by restore_date

Jeff Moden,

I 100% agree with you here. Why not outsource to USA. We have plenty of manpower here. And we can get cheap labor also. Let start from KS, OH,...

I agree. End of the story is no one can stop outsourcing technically speaking. Now if we talk about country then I would say Britian should be best place to...

Why outsource when we have manpower in US and technical ppl are willing to work on competative salaries. I work for a company which outsource DBA work. Trust me its...

if it shows 0 error then it means no error and database is fine. To assure nothing wrong with it also check sql server errror log and vevent viewer. if...

7 data and one log. that should work here.

did u monitor your disk activity durin query. Like disk queue length. can you monitor disk queue and memory. perfmon wil ltell you if any bottle neck happening. Besides...

apply sp3 if you can. is tempdb on raid 1?

Just qurious what patch you hav eon sql and it it 32 bit or 64 bit?