Answer the question
In order to leave comments, you need to log in
View all logs for a certain period of time?
An incomprehensible thing happens to the file server from time to time: the network share simply ceases to be available, after a while it releases it, but at some point everything repeats. I want to see the logs for the period when sql server could not write a backup to this ball, but I don’t know which log to look for. I make a custom view (custom view), but it does not allow you to select all the logs, first it warns:
The filter or custom view you are creating references more than 10 event logs. Ther result might perform poorly and consume a large amount of memory or processor time. Do you want to continue?
Event Viewer cannot open the event log or custom view. Verify that Event Log service is running or query is too long. The data is invalid (13)
Answer the question
In order to leave comments, you need to log in
You can reduce the amount of data output. Divide logs into several groups. Just in custom view.
You can also view and monitor through the sysinternals utilities.
You can also see the logs on the sql server, such as what prevented him from writing a backup there.
Still, there seems to be a limit on the size of the backup record over the network, xs I don’t remember how it’s called correctly. But it seems that the restriction was canceled somewhere on the server
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question