restore time VERY slow (compared to native SQL restore)
Restoring a database roughly 10Gb in size from a .sqb file takes avg 43min, compared to 1min for a native .bak restore.
First restored from network storage: 41min. Ok, maybe network I/O adds to the restore time, and it was compression level 4.
Ran a second backup (local copy, compression level 1) and restored from that: 46min! I have no idea why it'd take it longer to restore a local copy with less compression.
Compared to SSMS backup/restore (local storage): 3min backup, 1min restore. Same server, same time of day (server loading conditions).
Software Engineer / DBA
RenWeb School Management Software