Thank you

I will monitor these counters on Perfmon for next week and have a look.

Regards

I have made the incremental percentage 10% (as default)

I don't necessarily think this is an issue with the IO,

I am currently busy monitoring the following Counters in Perfmon:

Avg. Disk...

I have added an extra ndf for the temp database.

The user database already has a ndf.

Regards

Thank you.

But what do I do with my current situation?

Thanks.

But as stated in previous post.

We have the C:\ drive reserved solely for Windows.

The D:\ drive has the database files (mdf and ndf)

The E:\ drive has the logs

I am a...

Thanks for the update.

I was under the impression that the database files and log files should be on separate drives?

Currently the mdf and ndf are on D and ldf on...

These are local drives, not set up in a SAN

Regards

Thanks for the heads up. I will schedule a job for the rebuild

Will do, thanks a lot for the help and wisdom.

Luckily I'm still young, so I still have a loooong way to go 🙂

Okay, the database is currently synchronized. I have also set up a scheduled job to back up the logs every hour. This should keep the log size in tact?

650mb? :pinch:

The script only returned 2 rows

Okay, this is how I see it - The log file grew on the principal server and the mirror accordingly. I made a backup on the of the log on...

Thank you!

How will I know if the mirrored server fell behind?

It now returns 451 rows as to 817 earlier.

This should probably be decreasing the more t-log backups are made?

I tried shrinking just the log but nothing happened (the screen literally just vanishes).

So I shrunk the db, no errors came forth and the client now informed me that the...