
Hi @qasimidl ,
1.Please make sure you have the following memberships:
- securityadmin fixed server role on the SQL Server instance.
- db_owner fixed database role on all databases that are to be updated.
- Administrators group on the server on which you are running the PowerShell cmdlets.
2.You could use the following PowerShell commands to restore your SharePoint site:
Restore-SPSite -Identity <SiteCollectionURL> -Path <Backup file> [-DatabaseServer <DatabaseServerName>] [-DatabaseName <ContentDatabaseName>] [-HostHeader <Host header>] [-Force] [-GradualDelete] [-Verbose]
- <SiteCollectionURL> is URL for the site collection you want to restore.
- <DatabaseServerName> is name of the database server where the site collection resides.
- <ContentDatabaseName> is the name of the content database.
For Reference: Restore site collections in SharePoint Server
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.