Activity overview
Latest activity by mliu
Hi Peter,
When we tried to restore the log file without header, here is the error that we have been getting:
Thread 0 error:
Data decompression error: Access violation at address 0050BC83 in module 'SQBCoreService.exe'. Read of address 7FE9E28C
Server: Msg 3013
RESTORE LOG is terminating abnormally.
Server: Msg 3242
The file on device 'SQLBACKUP_06F8443D-3DC7-4F2E-B6D1-B0921AA23955' is not a valid Microsoft Tape Format backup set.
SQL Backup exit code: 790
SQL error code: 3242
Any ideas on how to resolve it?
Thanks / comments
Hi Peter,
When we tried to restore the log file without header, here is the error that we have been getting:
Thread 0 error:
Data decompression error: Access violation at address 0050BC83 in module...
Hi Peter,
Could you please let us know how we could restore the file without header?
Thanks / comments
Hi Peter,
Could you please let us know how we could restore the file without header?
Thanks
Error writing header to backup file using SQL backup 4.6
Hi,
Does anyone have ever run into the following issue?
It only happens from time to time, and it is not consistent. When SQL backup runs the scheduled log shipping file, it generates the log file;...
Hi Petey,
Below is the command that is used to run through Query Analyzer:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [dbname]
FROM DISK = ''\\primaryservername\SQLShare\LOG_(local)_dbname_20070404_121501.sqb''
WITH NORECOVERY, MAILTO_ONERROR = ''mei@calyxsoftware.com'',
ERASEFILES = 7, FILEOPTIONS = 1, PASSWORD = ''xxxxxxxxxxxx'',
MOVETO = ''D:\SQLBackup\SQLProcessed\''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
This particular log file that we run through Query Analyzer is only 24KB. We have started the processed 10 minutes ago, and it is still running....
Any ideas?
Thanks / comments
Hi Petey,
Below is the command that is used to run through Query Analyzer:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
exec master..sqlbackup N'-sql "RESTORE LOG [dbname]
FROM DISK = ''\\primar...
Hi Petey,
We have tried that several times, but the process just kept running, and never stopped until we stopped it manually. There wasn't any error message, or any other messages either.
What could we do to see what is really going on? If we run Profiler, what should we be looking at?
Thanks / comments
Hi Petey,
We have tried that several times, but the process just kept running, and never stopped until we stopped it manually. There wasn't any error message, or any other messages either.
What cou...
One more piece of information is as follow:
We have a test script that is exactly the same is the one that's not working. The only thing that's different is that the database is a test database. The job has been disabled since it was a test. We just ran that script from backup to restore. Everything worked just fine.
We are totoally puzzled as to why the same script will not work for the production database.
Any help and suggestion will be greatly appreciated.
Thanks / comments
One more piece of information is as follow:
We have a test script that is exactly the same is the one that's not working. The only thing that's different is that the database is a test database. Th...
We have tried it again. Currently, the behavior is that it has kept running for 15 minutes, and still running. The size of the log file that needs to be restored is only 275KB.
What could be the reason for this process keeps running?
Thanks. / comments
We have tried it again. Currently, the behavior is that it has kept running for 15 minutes, and still running. The size of the log file that needs to be restored is only 275KB.
What could be the re...
Here is the result:
(3 row(s) affected)
(3 row(s) affected)
Server: Msg 50000, Level 16, State 1, Line 6
SQL Backup job failed with exitcode: 220 SQL error code: 0
At the same time, we could see all of the log files from the primary server. / comments
Here is the result:
(3 row(s) affected)
(3 row(s) affected)
Server: Msg 50000, Level 16, State 1, Line 6
SQL Backup job failed with exitcode: 220 SQL error code: 0
At the same time, we could see a...
Restoring issue without any error message
Hi,
We are having a very werid issue where the restore stopped, even though the process keeps in running mode.
It doesn't restore any backups from the primary server. and all backup files are accum...
restore stopped with no error message
Hi,
We ran into a very weird issue where the backup works just fine, but the restore stopped without any error messages.
Could anyone let us know where to start looking into it as there isn't any l...