CODEWITHSUNDEEP
sql-server
user387268
user387268

Reputation: 39

SQL Backup location

Can somebody please let me know how I can output a list of the exact path and file name of each and every database that was backed up the last night.

Thank you

Upvotes: 0

Views: 129

Answers (2)

Jeff Freedman
Jeff Freedman

Reputation: 61

To view the log files in SSMS click the server name to expand the server tree. Then expand Management folder and expand SQL Server Logs. Double click it to see server logs.

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300599

Look in the SQL Server Logs (assuming you are talking about using SQL native Backup).

A question like this makes me want to ask "Why do you not know which DBs are being backed up and when?"

Upvotes: 1

Related Questions