This is a fairly generic question, I know. But, the .bak of my live SharePoint Foundation 2010 site is only 22GB. From what I'm reading, that's not a lot. Yet, when I run the following command in PowerShell:

Restore-SPSite http://myserver/ -Path C:\SharePointFiles\SiteBackup.bak -Force

...it typically takes over a day to do the restore. Not only that, but 60% of the time, I come back the following day to see this error:

Restore-SPSite : The site collection could not be restored. If this problem persists, please make sure the content d atabases are available and have sufficient free space.

What can I do to make my site restores have a better chance than a crap-shoot? I've found that I do have more luck restoring my site to a "vanilla" state before doing this actual restore, but... I just wish there was a way to restore a site that doesn't involve praying in order to avoid wasting a whole day watching an ill-fated restore attempt.

1 Answer 1


It depends on the system resources, But a site with 22gb should not take that much time. one more thing it also depends on the network. If you run the restore during the working hours, that's also slow down the process.

As my experience, any site collection is greater than 20GB should be moved into own content Database. that's a way it makes life easier. in your case, if you move the Site collection into own content DB, then for recovery

  • You have to perform the backup of the content DB
  • You have to restore the Content Database
  • then attach that DB to the web application.

The other error you are getting, Becuase your restore operation timed out and throws the error.

  • So, when you say "perform backup [and then restore] of/to content database," are you doing that in SQL Management Studio (as in, an actual database backup), or are you doing that in Central Admin... what utility(ies) are you using to do the backup/restore?
    – Christine
    Mar 7, 2016 at 17:56
  • i am using the SQL backup and restore.
    – Waqas Sarwar MVP
    Mar 7, 2016 at 18:09
  • If I use SSMS to do the restore, do I have to have a .bak that was made from a SSMS backup? Meaning, if my SharePoint admin gave me a .bak created in CA, do I need to go back and request a SSMS backup in order to do this?
    – Christine
    Mar 7, 2016 at 18:16
  • You need a SQL backup of the content db not shrepoint, in order to restore it in SQL server. you have to get from your sql admin or do it yourself
    – Waqas Sarwar MVP
    Mar 7, 2016 at 18:17
  • 1
    The other thing to watch out for is that SharePoint can't deal with 2 sites having the same ID on the same farm, so if you are restoring a previous backup you have to get rid of (detach the old content DB) first. Mar 7, 2016 at 18:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.