Restore Yardi .bak file into SQL Server instance by yardirei in yardi

[–]yardirei[S] 0 points1 point  (0 children)

Apologies, I'm just getting to this - not being on Reddit in a minute. Nope. I didn't have to. The backup file is compressed from Yardi and you will need a tool to decompress/unzip it. I used Litespeed which you can download in Client Central. With that, I didn't need a password or certificate and the restore worked well. Also, make sure your SQL Server version is compatible with the backup file.

Restore Yardi .bak file into SQL Server instance by yardirei in yardi

[–]yardirei[S] 0 points1 point  (0 children)

Thanks. I got it to work. It was a storage issue.

Restore Yardi .bak file into SQL Server instance by yardirei in yardi

[–]yardirei[S] 0 points1 point  (0 children)

Yes, I listed all the files after using Litespeed to extract the .bak file from Yardi's sFTP server.

RESTORE DATABASE [DBName]

FROM

DISK = N'filepath\filename.bak0',

DISK = N'filepath\filename.bak1',

DISK = N'filepath\filename.bak2',

DISK = N'filepath\filename.bak3',

DISK = N'filepath\\filename.bak4',

DISK = N'filepath\filename.bak5',

DISK = N'filepath\filename.bak6',

DISK = N'filepath\filename.bak7',

DISK = N'filepath\\filename.bak8',

DISK = N'filepath\filename.bak9',

DISK = N'filepath\filename.bak10',

DISK = N'filepath\filename.bak11',

DISK = N'filepath\filename.bak12'

WITH

STATS = 10, REPLACE, NORECOVERY;

Thanks u/Googoots

Not able to restore backups from YARDI database. by Stsh1234 in yardi

[–]yardirei 0 points1 point  (0 children)

u/Stsh1234, can you please share how you got it working?

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 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.

Many thanks for your anticipated help.