I am having a problem restoring a single SQL database. We are using Backup Exec 8.5 with the SQL option loaded, trying to restore to a Sequel 7.0 database. It looks like the restore works and reports successful. When I go into enterprise manager in Sequel it shows <database name> (loading). I found a document through another posting from Veritas to enter a statement in a Query Analyzer typing "restore database <name> with recovery" and this results in an error message as follows:
"Server: msg 4318, Level 16, State 1, Line 1
File 'Css_Peoria_Data' has been rolled forward to LSN 765000000163800001. This log terminates at LSN 0, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY option.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally."
I'm not sure what the last part of this is, where it talks about reissuing with norecovery option.
Any ideas out there?
"Server: msg 4318, Level 16, State 1, Line 1
File 'Css_Peoria_Data' has been rolled forward to LSN 765000000163800001. This log terminates at LSN 0, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY option.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally."
I'm not sure what the last part of this is, where it talks about reissuing with norecovery option.
Any ideas out there?