I am trying to restore our production Sharepoint 2007 server into a virtual environment.
I made sure to install Service Pack 1 (v 18.104.22.16819) of Sharepoint, as that's what's running in the production environment.
From our production server, in Central Administration, I performed a full farm backup. Checking the log there were 0 errors:
[8/18/2010 3:57:04 PM]: Completed with 0 warnings.
[8/18/2010 3:57:04 PM]: Completed with 0 errors.
[8/18/2010 3:57:04 PM]: Backup completed successfully.
[8/18/2010 3:57:04 PM]: ---
Then I copy the backup directory to the virtual server and from Central Administration choose:
Restore From Backup. I point to the backup directory that I copied, choose the full farm, and choose New Configuration. I update everything accordingly and then click OK, and the restore fails miserably.
I won't paste the whole log, but here is what I get throughout, in regards to each database:
[8/19/2010 10:04:12 AM]: Error: Object WSS_Content_Restore (previous name: WSS_Content) failed in event OnRestore. For more information, see the error log located in the backup directory.
SqlException: The media family on device 'C:\SharepointBackup\spbr0
1D.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE DATABASE is terminating abnormally.
When I go into SQL Server Management Studio (I installed 2008 on the virtual server, because that's what's currently installed on our sharepoint server), and I try to manually restore the .bak file 0000001D.bak, I get the error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
The media family on device 'C:\SharepointBackup\spbr0
0D.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476
Why aren't the MS SQL Server databases restoring properly?