Hi

We are busy refreshing a QA server. We restored the SQL DB from a prod backup.

After <g class="gr_ gr_169 gr-alert gr_tiny gr_spell ContextualSpelling multiReplace" data-gr-id="169" id="169">i</g> attach the app the web application the amount of "Current Number of Site Collections" for the database is not correct?

We have restored a few times now, and to different farms running Project Server...

Is this a backup issue or why would the SharePoint content DB show with one less Site Collection. 

When <g class="gr_ gr_346 gr-alert gr_tiny gr_spell ContextualSpelling multiReplace" data-gr-id="346" id="346">i</g> run PowerShell command to restore the PWA site it failed. 

(FYI, restored from a different farm and it worked and <g class="gr_ gr_444 gr-alert gr_gramm Punctuation only-ins replaceWithoutSep" data-gr-id="444" id="444">resolved</g> but my concern <g class="gr_ gr_485 gr-alert gr_gramm Grammar multiReplace" data-gr-id="485" id="485">remain</g> with our prod backups that might be faulty...)

Anyway, Friday afternoon here so <g class="gr_ gr_602 gr-alert gr_tiny gr_spell ContextualSpelling multiReplace" data-gr-id="602" id="602">i</g> will check back on Monday. Thanks

Hi,

According to your description, my understanding is that you tried to restore a content DB in QA from backup of PRODUCT.

Are the versions of QA and PRODUCT environment the same in SharePoint farm? If not, please make sure they are same.

You need to dismount DB before restoring a content database, then you could re-mount after restore.

About dismounting content database:

https://technet.microsoft.com/en-us/library/Ff607764.aspx

If site collections are still less one, you could try to backup and restore it separately.

About how to backup and store SharePoint site collection from one farm to another farm using PowerShell:

http://blogs.msdn.com/b/vrajas/archive/2012/02/22/backup-and-restore-sharepoint-site-collection-from-one-farm-to-another-farm-using-stsadm-commands.aspx

Feel freely to reply if there is any update.

Best Regards,

Dean Wang