SQL Server Question 2005/2008

Zack
Zack used Ask the Experts™
on
Heyas,

When you have scheduled tasks like backups, intergrity checks etc how do you find out where those backups and intergrity checks are stored. See Screenshots would be very much appreciated.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
screenshots?
Chief Database Architect
Commented:
hi

you can view thw output of the plan in the log file

for example :
 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\LOG\
\Log_Backup_Subplan_1_20100301134505.txt'

They will be specified in the SQL Maintenance Plan.
Check the logs, error logs for errros as well check the history in msdb database
ZackGeneral IT Goto Guy

Author

Commented:
My apologies for the delay in my response my net connection was down.

Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial