Hi I am attempting to backup the transaction log file to setup mirroring in SQL Server
BACKUP LOG CUSTOMER TO DISK ='K:\JonDB\CUSTOMER.trn' WITH INIT GO
And I receive
Processed 6587361 pages for database 'CUSTOMER', file 'CUSTOMER' on file 1. Processed 0 pages for database 'CUSTOMER', file 'CUSTOMER_log' on file 1. Processed 6 pages for database 'CUSTOMER', file 'CUSTOMER_log2' on file 1. BACKUP DATABASE successfully processed 6587368 pages in 969.013 seconds (46.948 MB/sec). Msg 3049, Level 16, State 1, Line 5 BACKUP detected corruption in the database log. Check the errorlog for more information. Msg 3013, Level 16, State 1, Line 5 BACKUP LOG is terminating abnormally.
Where is the error log? I have a lot of disk space available so it cannot be this. I need to create the backup of the database and transaction log file to setup mirroring I believe. If I can get around this step, it would be ideal.