Forum Discussion

Cappino's avatar
Cappino
Level 4
10 years ago

Restore Transaction Log - SqlServer2012

Hi all! we have problem with restore transaction log from netbackup. We have configured all like the documentation for try it, but the problem is this: 14-apr-2015 11.55.35 - begin Restore ...
7.5
Agent for Microsoft SQL Server
Backup and Recovery
Documentation
Linux
NetBackup
Remote Agent for Windows Servers
Restore
  • Dollypee's avatar
    Dollypee
    10 years ago

    This error is due to the fact that there's an open connection to the database. If overwriting existing database, please ensure no one is connected. Also ensure there's no I/O going to the DB. kill any existing process and restart the restore. If not, you can create a move template and restore to an alternate location. Thanks

Michael_G_Ander's avatar
Michael_G_Ander
Level 6
10 years ago

Have had issues where we needed to stop the reporting services to be able to restore

Also seen that having the SQL Studio manager can cause things like this

The SQL server logs might give an hint about the problematic service/process