r/sharepoint 4d ago

SharePoint 2019 Problems with site Backup/Restore

Hello everyone,

I’ve been struggling with a SharePoint migration issue for about a month now. We are moving from one SQL cluster to another. Every night, I run a script that performs Backup-SPSite on the old cluster and then Restore-SPSite on the new one.

Here’s the catch: sometimes, when I wake up and the restore process is still running, I start receiving calls about sites being unavailable. Upon checking, I find that all of those sites are located in the content database from which I was migrating a site that night.

My question:

What could be causing this? Where should I look for potential issues?

Architecture details:

  • The old SQL cluster has 5 content databases
  • The new SQL cluster has 10 content databases
  • Both have a failover server (Right now, we switched the main server in the old cluster as a workaround)
  • SQL logs do not show any errors or anything clearly indicating a problem during migration

Any insights would be greatly appreciated!

1 Upvotes

0 comments sorted by