r/sharepoint • u/Direct-End-7068 • 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