Missing List items from Sharepoint Restore
Hello all,
I've been tasked with backing up/restoring data from a sharepoint 2013 farm and having issues with seeing the list items on restore.
I've added the RAWS to the SQL box(2012 SQL/2008 server) and to the sharepoint box(2012 R2 server) and was able to add the farm with out issue and I can do a backup of the farm without any errors. The system logon account has DB_Owner to the DBs on SQL and has all admin rights under sharepoint. I've even tested with another account and get the same results. Also Instant GRT is enabled.
I did test this on a sandbox sharepoint but the main difference is, SQL is installed on the same box as sharepoint. I was able to backup the farm and see all list items and even restore single list items.
I've talked with support and they where no help at all. Would anyone have any ideas on what I'm missing? If I've missed any information please let me know I should be able to provide.
Thanks