Activity overview
Latest activity by wpa
Yes I see.
I have upgraded to v4.6 and re-activated and it's now working.
Thanks for your help. [image] / comments
Yes I see.
I have upgraded to v4.6 and re-activated and it's now working.
Thanks for your help.
Yes - I've just done a Redgate backup of a 9gb database to the disk. Then deleted the database and restored from the .sqb file on the disk.
All OK.
I've just checked and the sqlbackupC.exe version are different on the backup server to that on the restore server.
Version 4 on backup server. Version 3.2 on restore server.
So, is it not backwards compatible? / comments
Yes - I've just done a Redgate backup of a 9gb database to the disk. Then deleted the database and restored from the .sqb file on the disk.
All OK.
I've just checked and the sqlbackupC.exe version ...
Hi Peter - thanks for replying.
I get Error 530: File does not exist: F:\backupdbtest\naxosdb_01.sqb
when I try the HEADERONLY option.
The disk I'm using for the .sqb files is a cheap USB 400gb one formatted as FAT32. (samsung HD400LD). It is unable to handle large files (eg 15gb) as I cannot copy such files to it. I guess this is a FAT32 limit.
However, my sqb files are 2gb each and have already been used to restore successfully on a different server yesterday.
The 'good' server is Win Server 2000 SP3
The 'bad' server is Win Server 2003 SP1
I'm thinking of formatting the disk as NTFS and starting again.
What do you think? / comments
Hi Peter - thanks for replying.
I get Error 530: File does not exist: F:\backupdbtest\naxosdb_01.sqb
when I try the HEADERONLY option.
The disk I'm using for the .sqb files is a cheap USB 400gb on...
SQLBackup Restore I-O Error
I'm getting the following error when trying to restore a multi-sqb backup set:
Restoring database naxosdb_test from "F:\backupdbtest\naxosdb_01.sqb"
Msg 3203, Level 16, State 1, Server NAXOSSQL01, ...
Found it! Someone had put disk compression on the disk used for the database files. Microsoft says SQLServer database files should not be compressed - leads to rrandom I/O errors. This would explain why we have been having other random I/O errors on that server for months! [image] [image] [image] / comments
Found it! Someone had put disk compression on the disk used for the database files. Microsoft says SQLServer database files should not be compressed - leads to rrandom I/O errors. This would explai...
Restore fails with Nonrecoverable I/O error on file '???'
I am using SQLBackup v 3.2.0.1 to restore from a .sqb file on a network share. I don't have enough space to put the .sqb locally. Any ideas?