Hi

You might also want to check out the Microsoft Virtual Academy Training link below.

https://mva.microsoft.com/en-US/training-courses/designing-database-solutions-for-sql-server-8484?l=HN0uqzXz_3704984382

Watch the video on "Designing a Backup Recovery Solution for SQL Server"

I hope this helps.

Thanks

Best...

Hi!

What are the errors shown in your SQL error logs?

Have you checked this link? https://support.microsoft.com/en-sg/kb/2857849

Thanks

Best REgards,

Hi

You may try the script below to query the SQL error logs. There you will see when a failover happened.

declare @Time_Start datetime;

declare @Time_End datetime;

set @Time_Start=getdate()-2;

set @Time_End=getdate();

-- Create the...

Hi

You may refer to the link below.

https://msdn.microsoft.com/en-us/library/ff878487.aspx

There is a section in the article about prerequisites and restrictions for using a SQL Server Failover Cluster Instance (FCI) to...

Our issue has been resolved after rebooting the server.

Hi All,

You may try the script below. it is an enhanced version of the blocking query. Additionally, it captures the blocked table and index name.

;WITH T1 AS (

...

Hi

"but the job in Node 1 will stop after a few seconds" what I mean is this job will successfully run too but it wont create a backup file in...

Hi Durai Nagarajan,

Set up your existing SQL jobs on both nodes but disable the jobs on your secondary replica. The reason for this is that in case you encounter failover,...

Hi

No. We haven't. Have you encountered this problem as well?

Best Regards,

Hi Daniel Hughes,

Have you resolved the problem? What did you do?

Thanks

Best Regards,

Hi Grasshopper,

you may use the query below to check which index/es consumes most buffer pool memory.

USE DB_Name;

GO

;WITH src AS

(

SELECT

[Object]...

If your database has a lot of modifications you may want to push that log backup time down to 15 mins or half hour.

Acceptable data loss window.

Yes. Those are great...

Hi Mike,

Below is the better backup strategy:

- Full backup every night

- Differential every 6 hours.

- T-log backups every 15 mins. or (30 mins.)

This backup strategy is easier to manage and...

HI

There will be no impact to the logshipping when you shrink the logfile. The Logshipping will NOT break.

Thank you.

Best Regards,

Hi

You might want to check out the index maintenance script from this site. https://ola.hallengren.com/

This stored procedure will allow you to set corrective actions based on the %fragmentation level...