I have a DB of 800GB+ that I need to restore to another server. We don't have another server that can take a DB of that size. The DB is in two file groups.
The Dev server I want this DB restored to has one drive that can take one of the datafiles. I have located spare disk space on another external USB drive.
I want to restore the DB from the backup (using a UNC path to the backup) on to three drives - one local and two using UNC paths to the external drive. MDF to a UNC path, the NDF to the local drive and the LDF to a UNC path.
I get the following error:
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "DB NAME" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
"Restore Verifyonly" comes up as the Backup is valid. I have used several backups and they all generate this error.
Any ideas on what this error is (I have googled and found no response that can help me) and how I can get thriugh this restore is very much appreciated.