SQL Database restore log file path
I have problem with restore database to MSSQL 2008 R2 to original instance and database. Restore job fail because BE restore LDF file to root of drive where is original log file path instead of original path. In the original path make LDF file same name but 0 byte size. SQL server then write this event to ERRORLOG:
spid53 Starting up database 'ContentDB'.
Backup Error: 3283, Severity: 16, State: 1.
Backup The file "ContentDB_log" failed to initialize correctly. Examine the error logs for more details
When I use option restore to redirect instance and specify the original instance and path the restore is successful. But I can’t specify different path for MDF and LDF file.
I use Backup Exec 2012 SP1