Comments
Sort by recent activity
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
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...
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...
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...
Hi Chris,
Thanks for your reply. The issue was raised because our software only worik with MS SQL SP2 or earlier. It is indeed unfortunate.
Is there a workaround that we couuld still make it to fit in our needs?
Thanks. / comments
Hi Chris,
Thanks for your reply. The issue was raised because our software only worik with MS SQL SP2 or earlier. It is indeed unfortunate.
Is there a workaround that we couuld still make it to fi...
Hi Peter,
Our requirement is to see whether there will be a way to copy the logs onto a different machine while it does the log shipping. Let's say we have a source servern and a destination server, and we are doing the log shipping from the source to destination. Currenly, it is only possible for the desitnation server to get the logs from the source within your software.
What we are looking for is to see whether there will be a way to copy the logs onto a third server. This is the similar backup strategy that you currently have in mirrored backups when log shipping is not used where it can actually copy the backup files onto different machines/disks simulteneuously.
Thanks. / comments
Hi Peter,
Our requirement is to see whether there will be a way to copy the logs onto a different machine while it does the log shipping. Let's say we have a source servern and a destination server...
Hi Peter,
Thanks for your quick response.
Does this mean that we have to manually modify the job SQL Bakcup creates? Or is there an option to do so? I didn't see it...
Thanks. / comments
Hi Peter,
Thanks for your quick response.
Does this mean that we have to manually modify the job SQL Bakcup creates? Or is there an option to do so? I didn't see it...
Thanks.