Search code examples
sql-serverdatabase-backupsdatabase-restore

Restore Yardi backup (.bak) files to SQL Server

I have a SQL Server 2022 Developer instance that I believe will be higher than the Yardi one. I have extracted it using Litespeed into 13 different files as suggested here but I get "The file ID 1 on device is incorrectly formed and can not be read" when I run the Restore Database with replace, no recovery query. The BackupName = *** INCOMPLETE ***, Position = 1 and other fields are NULLs when I run the Restore Headeronly query. Any help will be appreciated. Many thanks for your anticipated help.

I tried restoring using SSMS and I'm expecting the restore to work and create a database with the data in the backup files.

Solution

  • The extracted file size was about 4 times the compressed file. The storage space I had in my drive was not enough so I had to increase it. Thanks All!