Activity overview
Latest activity by ron
Thanks,
Can you please tell me how soon it will be released? / comments
Thanks,
Can you please tell me how soon it will be released?
header only works just fine.
SQL Backup (DLL v4.0.0.113)
Reading SQB file header of "\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb"
Backup group ID : 111617709
File number : 1 of 1
Backup type : 1 (Database)
Backup size : 2.438 MB
Backup start : Wednesday, February 01, 2006 10:28:22 AM
Backup end : Wednesday, February 01, 2006 10:28:22 AM
Server name : SYS-RGE05
Database name : ArchiveDB
First LSN : 10000000012300001
Last LSN : 10000000012500001
Checkpoint LSN : 10000000012300002
Differential base LSN : 10000000011200002
(19 row(s) affected)
name value
exitcode 0
sqlerrorcode 0
filename01 \\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb
(3 row(s) affected) / comments
header only works just fine.
SQL Backup (DLL v4.0.0.113)
Reading SQB file header of "\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb"
Backup group ID : 111617709
File number : 1 of 1
Backup ...
Here is what I get trying to restore. I changed the password for obvious reasons.
ArchiveDB
-SQL "RESTORE DATABASE [ArchiveDB] FROM DISK = [\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb] WITH move [ArchiveDb_Data] to [e:\mssql\data\ArchiveDb_Data.mdf], move [ArchiveDb_Log] to [e:\mssql\data\ArchiveDb_Log.ldf], password = [xxxxxxxxx] , replace "
SQL Backup (DLL v4.0.0.113)
Restoring ArchiveDB (database) from:
\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb
\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb.log.txt
Error 570: File is not a SQL Backup file.
SQL Backup exit code: 570
(7 row(s) affected)
name value
exitcode 570
sqlerrorcode 0
filename01 \\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb
filename02 \\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb.log.txt
(4 row(s) affected)
******************************
ArchiveDB restore failed
****************************** / comments
Here is what I get trying to restore. I changed the password for obvious reasons.
ArchiveDB
-SQL "RESTORE DATABASE [ArchiveDB] FROM DISK = [\\densrvuasql01\d$\sys-rge05_backup\ArchiveDB.sqb] WITH ...
It does. It has no problems writing to the network share and can read from it for setting up the restore in the GUI. If the source is encrypted I get the the check mark in the GUI indicating that I have I have supplied the correct password. It just can't restore the database. / comments
It does. It has no problems writing to the network share and can read from it for setting up the restore in the GUI. If the source is encrypted I get the the check mark in the GUI indicating that...
I have discovered that I with version 4 I can backup to network share just fine. I can not restore from a network share.
The scripts I am using work just fine in version 3.x for backing up and restoring from a network share
The network share is used by about 20 sql servers running red-gate backup 3.x for their backup destination and it works just fine.
Using the 4.x GUI I backed up just fine to the network share and a local drive.
When I try to restore through a script or the GUI I get a 570 error when restoring from the network share and the restore runs when restoring from a local drive.
I removed version 4.x from the server and put version 3.x on the server and it now restores the 3.x backups from the network share just fine. The server was a new server setup yesterday that never had 3.x on it. I started with 4.x but it did not work. / comments
I have discovered that I with version 4 I can backup to network share just fine. I can not restore from a network share.
The scripts I am using work just fine in version 3.x for backing up and res...
The GUI can read the backup file, knows it is encrypted, gives me a check mark when I supply the password but when I try to do the restore I get this error.
Restore dbname
Restoring AuthDB (database) on DBA instance from:
\\backup_path\dbname.sqb
\\backup_path\dbname.sqb.log.txt
Error 570: File is not a SQL Backup file.
SQL Backup exit code: 570 / comments
The GUI can read the backup file, knows it is encrypted, gives me a check mark when I supply the password but when I try to do the restore I get this error.
Restore dbname
Restoring AuthDB (databas...
yes, the backup file is encrypted. / comments
yes, the backup file is encrypted.
restore previous version backups
I will admit that I have not read the manual.
Can version 4 restore backups from version 3? I did a quick test and it failed telling me it was not a valid backup file.
Thanks,
Ron
I have solved this.
The server has 4 gig of memory and was using the 3gb switch. I removed the 3gb switch and rebooted the server.
Backups now run normally. / comments
I have solved this.
The server has 4 gig of memory and was using the 3gb switch. I removed the 3gb switch and rebooted the server.
Backups now run normally.
We have specific naming conventions for backups and the copyto option will not overwrite existing files so it is going to be a pain to implement.
I continue to get this error message on the server while SQLlitespeed continues to backup this server just fine.
Warning: System error code: (Insufficient system resources exist to complete the requested service)
Msg 3202, Level 16, State 1, Server xxxxxxxx, Line 1
Write on 'SQLBACKUP_177406493' failed, status = 112. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Server xxxxxxxx, Line 1
BACKUP DATABASE is terminating abnormally.
How do I resolve this error message? I have about 6 other servers backing up to the same network location using red-gate backup and they work just fine. / comments
We have specific naming conventions for backups and the copyto option will not overwrite existing files so it is going to be a pain to implement.
I continue to get this error message on the server ...