Link to home
Create AccountLog in
Avatar of rafaelmunoz2
rafaelmunoz2

asked on

Create and manage databases and their related components, maintain, and use stored procedures,

How do I automate and use special monitoring to perform on database used for a website? I am using MS SQL and I have to complete a project and take shoots of my steps. Thanks
Avatar of ptjcb
ptjcb
Flag of United States of America image

Which version of SQL Server?
Avatar of rafaelmunoz2
rafaelmunoz2

ASKER

SQL EXPRESS EDITION
SQLExpress does not have the ability to run jobs, which is what is used to automate and monitor tasks in SQL Server).

What is the exact wording for the assignment?
The exact wording is;

"Describe what maintenance tools and functions are available in SQL Server 2005.

What special monitoring should you perform on a database used for a website and why? Are there ways you can automate this type of monitoring?"

But I have to actually perform this in after a discussion. I have SQL Express, what should I do to get this done? Can it be perform with what I have now?
ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ok, I see, sorry, I am getting the picture now. Thanks for your time and help...
Cool. Glad I could help.