question

serdia avatar image
serdia asked

How to find out the time when command failed in sql server?

I was performing dile shrinking using GUI. After more than 10 hours I got an error, saying that the shrink command failed.

But how can I see exact time when it happened? I would think it's one of the most important detail.

The log doesn't even have a file for 2/8/2022.

I tried to query error log and find the message error but not success.

So how to find the time when job failed?


1644428144431.png

dbasqlservererror-message
1644428144431.png (76.0 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.