The purpose of this job is to comparison of fragmentation before & after the the maintenance job. I am comparing two excels manually.

Some how I don't want to create...

To reduce the VLFs. I saw when the log file is large it has more no of vlfs

My Understanding is below

so either rebuild index or reorg index will use the transactional log and increase the physical log usage.

so if the log file initial size is 50MB...

Is it possible to use temp db for reorg index job like rebuild index instead of log?

In that case we need to take everyday full backup right?

Currently we have weekly full backup & 15 min log backups.

HI,

I am able to send the email by setting up the below

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'SQL DBMail',

@recipients = 'ramana@yahoo.com',

@query...

Hi Lynn,

Thanks for your reply.

I am not clear about some questions

1) Does Reorganizing 5 indexes on a table and rebuilding the 5 indexes on the same table requires same log?

2)...

So i.e. in my case the backups are not marking the VLF to reuse.

What could be the reason? Is this could be a bug?

Is rebuild Indexes also requires the same...

I honestly speaking, I don't have any exact information.

Under the jobs, I can see there are backup jobs Full & Transactional scheduled. When I click on that it is showing...

Thank you

It included the new database also.

I am looking to set up the differential backup. I will look in to the documentation. Thanks for providing the documentation

Hi,

Another point to note here is that table is replicating and the table has more than 55000000 records greater than 3 months. Is this no of rows are ok to...

Thank you

Well for this I have to use the same server but to the different db

The no of reads & writes on the table are equal. Every 15-20min there will be update on the table