you are right. I am having less space on mirror , so after clearing it has sorted out...

hi Steve

thank you for your reply. I am sure, we are using synchronous mode only. But one concern is mirroring "used to" work properly but on suddenly during business day...

hi richard

thank you very much for reply.

so from your notes, size of tlog does nt affect your db mirror slow performance. So how can i debug to know which is...

Version 1:(experimenting with rebuilding indexes)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1. I created a sample db called sam1 from a full backup (of last night live size: 275, 796 KB)

2. After restoring immediately I took a...

thanks alot people for your time and help. I really respct your time but I would like to know should I rebuild or reorganize indexes before taking full backup or...

we are not doing any transaction log backups. My DBA has setup diff backups for every...

particularly re-index jobs / Index rebuilds?

Even I have seen similar answer in other forums as well. may i know where can I see these settings to enable/disable? because even I...