Activity overview
Latest activity by SamC
SQL 2005 - Backup Job
I'm new to SQL 2005, but in 2000, if RedGate Backup creates a backup job, I can see the job in Enterprise Manager, Managment, Jobs.
Where is the corresponding backup job found in 2005's SSMS?
Sam
I haven't seen this problem since my last post. I'm also running the most recent update.
Try: HELP, Check for Updates / comments
I haven't seen this problem since my last post. I'm also running the most recent update.
Try: HELP, Check for Updates
Resolved
Resolved
SQL Backup Update Error
After downloading the May 10 update for SQL Backup, the following error message appears before installation begins:
Some files that need to be processed are currently in use.
The following applica...
Brian,
Wanted to let you know that I unzipped and installed the SQL Backup update.
Unfortunately the problem doesn't seem to be corrected with this update.
Sam / comments
Brian,
Wanted to let you know that I unzipped and installed the SQL Backup update.
Unfortunately the problem doesn't seem to be corrected with this update.
Sam
The converted transaction log file restores properly with EM. / comments
The converted transaction log file restores properly with EM.
I re-ran the restore again. It seems to fail on the same transaction log.
5/4/2005 8:18:22 AM: Restoring file: [image] \Program Files\Microsoft SQL Server\MSSQL\BACKUP\nimc\LOG_(local)_nimc_20050504 054500.sqb
There's no proprietary data in this transaction log. I can provide a zipped copy (5Kb) for your review. / comments
I re-ran the restore again. It seems to fail on the same transaction log.
5/4/2005 8:18:22 AM: Restoring file: \Program Files\Microsoft SQL Server\MSSQL\BACKUP\nimc\LOG_(local)_nimc_20050504 05450...
I don't know which log file failed to restore. That's part of the problem with the SQL Backup Log output:
----- SQL Server messages -----
Processed 2 pages for database 'nimc', file 'nimc_Log' on file 1.
RESTORE LOG successfully processed 2 pages in 0.002 seconds (7.168 MB/sec).
5/4/2005 8:18:22 AM: Restoring file: D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\nimc\LOG_(local)_nimc_20050504 054500.sqb
5/4/2005 8:18:22 AM: Restore started ...
----- SQL Server messages -----
Msg 3242, Level 16, State 1, Server VAIO3, Line 1
The file on device 'SQLBACKUP_8510493' is not a valid Microsoft Tape Format backup set.
Msg 3013, Level 16, State 1, Server VAIO3, Line 1
RESTORE LOG is terminating abnormally.
There's no indication of which file was at fault.
I'll try to locate the file today by restoring the transaction logs individually. Assuming the logs are processed individually, it's number 16 out of 22 transaction logs. / comments
I don't know which log file failed to restore. That's part of the problem with the SQL Backup Log output:
----- SQL Server messages -----
Processed 2 pages for database 'nimc', file 'nimc_Log' on ...
Error on restore of Transaction Log
After restoring multiple transaction log files successfully, SQL Backup terminated with "Restore Failed" with the message "Log file is not a valid tape backup".
It is only then that I realized the ...
Deleting old Log Files
There are hundreds of individual SQL Backup log files accumulating somewhere under
\My Documents\...\SQL BackupIs there any automated method to retain the last week or so?