When you do a SQL restore job in NetVault 10 it will running without completing. The log will display below lines without any error message.
2015/10/22 10:37:58 63 1 Media NETVAULTBK-SVR (VTL LIBRARY) Media in 'DRIVE 5:NETVAULTBK-SVR' assigned to job ready for data transfer
2015/10/22 10:37:58 63 1 Media NETVAULTBK-SVR (VTL LIBRARY) Job has been assigned media 'SQL_MEDIA' (PSYDD004) in 'DRIVE 5:NETVAULTBK-SVR'
2015/10/22 10:37:58 63 1 Data Plugin SLSB-DB-01 Restoring database 'Lease'
2015/10/22 10:37:57 63 1 Data Plugin SLSB-DB-01 Restoring Server: <SQL-Server-Name>\DB-Name
2015/10/22 10:37:57 63 1 Jobs NETVAULTBK-SVR Starting job 63 '001' (Phase 1 , Instance 1) for UID 1
To fix this issue log in to your SQL Management and go to relevant database.
Right click the database and go to properties. In the Options, at the bottom, Restrict Access option is set to MULTI_USER. Change it to SINGLE_USER. Then restore the database.
After the restore, the Restrict Access will be changed back to MULTI_USER. Double check to be sure. If not change to MULTI_USER.
Leave a Reply