yes. it's a prod database.

yes but hung.

Hi Sanket,

you mean it's the "maximum worker threads:"?

Tried already to restore the 10 PM transaction log but showing same error.

We don't have 10:30 PM transaction log.

What we is hourly transaction log backup.

10:00 PM - Transaction Log

10:30 PM - Full Backup (every day)

11:00 PM - Transaction Log

12:00 AM - Transaction...

The full backup completed at 11:00 PM

Error:

System.Data.SqlClient.SqlError: The log in this backup set begins at LSN #, which is too recent to apply to the database. An earlier log backup...

Hi Everyone,

I cannot restore the transaction logs after restoring the full backup.

It shows the transaction log is too early to apply. I have the following scheduled jobs to take backup...

haha.. it's a minor mistake 🙂 thanks for your help!

It has no database repair on DBCC CHECKDB? How about if the database has been mirrored?

It means the average 95% memory usage is normal?

the percentage of SQL memory usage has an average of 95% so I want to reduce it to improve the SQL performance.

just want to ask if we have standard max memory? is 4096 is the standard? The total RAM memory is 35 gb.

Thanks guys.. currently the max server memory is 28672 MB.