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.