This is just the schedule.

It should run every saturday. Are you ok with that? Did it run successfully?

Can you show the maintenance plan settings?

What are you expecting to...

Try to run SSMS as an administrator. Does it help?

It really depends on how you set up the maintenance plan.

Can you post some more info please?

If it's not asking for a password, I suppose you're creating a database user and not a login.

Use scripts, not the GUI.

CREATE LOGIN test WITH PASSWORD = 'test'

USE yourdatabasename;

CREATE USER...

This thread discusses the issue in depth

Are you getting errors? Show something more please.

jacksonandrew321 (11/3/2014)

---

Hi Folks

I scheduled automatic backup process but its only showing backup of the only one .sql file in the backup folder. Other created .sql files are not backed up....

Shrinking tempdb should be an exceptional operation, not something you do every week. Why are you...

Enterprise Policy Management Framework[/url] seems to be what you're after.

Works quite well if your instances are all the same version. It has some issues with old SQL 2000.

Other than...

The default trace should contain a row for that change.

This should show you where the trace file is located:

SELECT *

FROM sys.traces

Yes, that will work, assuming those ndfs are in the same filegroup as the mdf.

What's the database recovery model?

If it set to "FULL", your log will grow bigger and bigger without a backup process to truncate it.

If you can't afford taking log backups on...

From the ODBC DSN configuration.

You can also attach a screenshot to your reply if you want.

OK, this is the message you get from the service start operation.

What I wanted you to share is the contents of the SQL Server Agent log, which is located in...

What does the SQL Server Agent log say? What's the error?