How can we help you today? How can we help you today?
brosato
Activity overview Badges (0) Posts (16) Comments (57)

Comments

Sort by recent activity
I can't seem to get restores to finish either. I'm calling the extended procedure. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. restore time VERY slow (compared to native SQL restore)
I can't seem to get restores to finish either. I'm calling the extended procedure.
0 votes
I use the With Mailto option. I set up a filter in Outlook to move all success emails to a folder and only leave failures in my inbox. Works pretty well. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. creating a report on restores
I use the With Mailto option. I set up a filter in Outlook to move all success emails to a folder and only leave failures in my inbox. Works pretty well.
0 votes
Yep, that fixed it. Thanks for the quick fix. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
Yep, that fixed it. Thanks for the quick fix.
0 votes
Ahh, lucky 13 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
Ahh, lucky 13
0 votes
I just tried again. It tried to restore logs but I assume it's the wrong ones. Here's the output. Restoring Ektron (database) on dba instance from: \\Recovery\SQLBackups\Thor\Ektron\FULL_20100725_023013.sqb Processed 102840 pages for database 'Ektron', file 'EverestEktronDev' on file 1. Processed 2 pages for database 'Ektron', file 'EverestEktronDev_log' on file 1. RESTORE DATABASE successfully processed 102842 pages in 117.873 seconds (6.816 MB/sec). Restoring Ektron (database) on dba instance from: \\Recovery\SQLBackups\Thor\Ektron\DIFF_Ektron_20100730_023011.sqb Processed 7384 pages for database 'Ektron', file 'EverestEktronDev' on file 1. Processed 1 pages for database 'Ektron', file 'EverestEktronDev_log' on file 1. RESTORE DATABASE successfully processed 7385 pages in 46.030 seconds (1.253 MB/sec). Restoring Ektron (transaction logs) on dba instance from: \\Recovery\SQLBackups\Thor\Ektron\LOG_Ektron_20100730_064503.sqb Thread 0 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 1 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 3 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 4 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 5 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 6 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 7 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 8 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 9 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) Thread 10 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally. SQL error 4305: SQL error 4305: The log in this backup set begins at LSN 16634000000669900001, which is too recent to apply to the database. An earlier log backup that includes LSN 16634000000591800001 can be restored. SQL Backup exit code: 790 SQL error code: 4305 / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
I just tried again. It tried to restore logs but I assume it's the wrong ones. Here's the output. Restoring Ektron (database) on dba instance from: \\Recovery\SQLBackups\Thor\Ektron\FULL_20100725...
0 votes
It skipped 13 earlier log files. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
It skipped 13 earlier log files.
0 votes
Here's the entire command I'm running also. EXEC master.dbo.sqlbackup '-SQL "RESTORE DATABASE Ektron FROM DISK = [\\Recovery\SQLBackups\Thor\Ektron\*.sqb] LATEST_ALL with MAILTO = [me@mycompany.com],RECOVERY,REPLACE, SINGLERESULTSET, PASSWORD = [Password], MOVE [EverestEktronDev_log] TO [C:\TEMP\Ektron_log.ldf], move [EverestEktronDev] to [C:\temp\Ektron.mdf]" -I dba' / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
Here's the entire command I'm running also. EXEC master.dbo.sqlbackup '-SQL "RESTORE DATABASE Ektron FROM DISK = [\\Recovery\SQLBackups\Thor\Ektron\*.sqb] LATEST_ALL with MAILTO = [me@mycompany.com...
0 votes
Here you go. First 3 after the diff. Backup start : 7/29/2010 10:15:05 AM Backup finish: 7/29/2010 10:15:05 AM First LSN : 16630000000491400001 Last LSN : 16630000000491600001 Checkpoint LSN : 16630000000491400001 Database backup LSN : 16603000000066900038 Differential base LSN : NULL Backup start : 7/29/2010 10:30:04 AM Backup finish: 7/29/2010 10:30:04 AM First LSN : 16630000000491600001 Last LSN : 16630000000491900001 Checkpoint LSN : 16630000000491400001 Database backup LSN : 16603000000066900038 Differential base LSN : NULL Backup start : 7/29/2010 10:38:17 AM Backup finish: 7/29/2010 10:38:17 AM First LSN : 16630000000491900001 Last LSN : 16630000000585500001 Checkpoint LSN : 16630000000491400001 Database backup LSN : 16603000000066900038 Differential base LSN : NULL / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
Here you go. First 3 after the diff. Backup start : 7/29/2010 10:15:05 AM Backup finish: 7/29/2010 10:15:05 AM First LSN : 16630000000491400001 Last LSN : 16630000000491...
0 votes
Backup start : 7/25/2010 2:30:18 AM Backup finish: 7/25/2010 2:30:24 AM First LSN : 16603000000066900038 Last LSN : 16603000000069100001 Checkpoint LSN : 16603000000066900038 Database backup LSN : 16479000000778900038 Differential base LSN : NULL Backup start : 7/29/2010 10:02:02 AM Backup finish: 7/29/2010 10:02:04 AM First LSN : 16630000000491400001 Last LSN : 16630000000491600001 Checkpoint LSN : 16630000000491400001 Database backup LSN : 16603000000066900038 Differential base LSN : 16603000000066900038 SQL Backup process ended. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
Backup start : 7/25/2010 2:30:18 AM Backup finish: 7/25/2010 2:30:24 AM First LSN : 16603000000066900038 Last LSN : 16603000000069100001 Checkpoint LSN : 16603000...
0 votes
I'm using LATEST_ALL option by itself and I am using the patch. The backups don't have to originate from a patched install do they? The only one that's patched is the one I'm trying to do the restore to. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. RESTORE LATEST_ALL never starts
I'm using LATEST_ALL option by itself and I am using the patch. The backups don't have to originate from a patched install do they? The only one that's patched is the one I'm trying to do the res...
0 votes
Total activity
92
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
19