I'm running some restoration activity as part of a rehearsal to prepare for an actual SQL server upgrade from 2008 to 2022. We're planning to restore the backups taken...

We have Avamar here and we are testing it out?...

Thank you Jeff, Please find my inline response below.

If those backup drives are on the same system as your SQL Server, you need to move them to a different...

Ofcourse, I am waiting for the next maintenance window or a failover to happen :-D.

The number of VLFs are to be seen per database and will be handled at startup/recovery time ( of the database, as a step in the startup of the...

What's the TARGET_RECOVERY_TIME and recovery interval that has been configured on your databases ? Both values are set to '0'

added: How many VLFs are to be handled...

Create a DML audit on that and double check the data cant be inserted from outside. Next time when the issue pops up , check the DML audit log to...

Hi,

Need your help. I've a SP that is using Update statement on a table.

2-3 processes are updating this table at the same time. I'm getting frequent blockage. How can...

Hi,

Need your help. I've a SP that is using Update statement on a table.

2-3 processes are updating this table at the same time. I'm getting frequent blockage. How can...

Are there indications for the slow operation in the sql server errorlog files?:I couldnt find anything specific in sql error log during the recovery phases

Is the always on node...

Thank you Johan for the response. Please find my inline comment

Is this a clustered sql server instance ?Yes, its a 3 node windows cluster in which 2 nodes are...

You mean Geo-Replicas for your Azure SQL Managed instance? If its...

Really appreciate your effort and thanks for sharing the wonderful script.

Will be more beneficial if you can include hostname & loginname.

Happy New year

duplicate posts

• This reply was modified 3 months, 3 weeks ago by  VastSQL.