Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Where can I find information about errors while performing back up, copy or restore operations?

April 26, 2017copy errors operations Performing restore

0

Posted

Where can I find information about errors while performing back up, copy or restore operations?

1 Answer

0

Posted

• Open SQL Server Enterprise Manager, and then connect to the monitor server. • Under Management, click Log Shipping Monitor. In the right window pane, all the log shipping pairs are displayed (that have been configured with this server as the monitor server). If the log shipping pair is not visible, right-click the Log Shipping Monitor (under Management), and then click Refresh. • Right-click the log shipping pair that you want information about, and then click View Backup History to view the back up job history. • Right-click the log shipping pair, and then click View Copy/Restore History to view the history for copy and restore jobs. • Right-click the log shipping pair, and then click Properties to view the current log shipping status, Source, and Destination alert status.Q4: Does the file name first_file_000000000000.trn indicate that the copy or restore job was unsuccessful? A4: Each run of the copy and restore job is associated with at least one file. By default, if no files are