Seems file creation/FTP is the old school way of doing things (but probably still the fastest). From a SQL Server standpoint:

1. What recovery type is your SQL Server...

For each plan there are individual tasks, right click and choose 'Edit' or double click one of those tasks (they are the boxes in the plans that have arrows coming...

Sorry, I should have been more clear =)

Go to the maintenance plan, right click and choose 'Modify'. I was looking at one of my backup plans, so I chose...

Dump the SQL from the job, it should allow to 'View T-SQL'. It'll give you more info, we can then start down the sys.databases path.

Thanks Steve, that makes sense.

So next newb question: has someone done this with Powershell/VBScript?

Try putting brackets around the database name:

select name from [QA_WSS_Search_NSAB-SS82-SPF-N].dbo.sysfiles;

go

SQL no likey the dash, probably sees it as a minus sign.

Congrats on the new position, I found myself in similar circumstances. I went thru this book:

http://www.microsoft.com/learning/en/us/book.aspx?ID=9364&locale=en-us

and was able to pass the test on the first try. ...

johnyjj,

Here's a link to get SSMS express installed:

http://msdn.microsoft.com/en-us/library/ms365247.aspx

I'm not sure with the Express edition, but with full installs, if you don't choose to install the "tools, documentation" option,...

I know this is an old post, but I'm having the same problem. Based on research I've already changed:

allow updates to 0

CPU and I/O affinity set to Automatic

Seems others...

Thanks so much Gail. Do you think my database was backed up properly?

I guess I shouldn't have asked the question, as it isn't pertinent to the issue. I'm trying to find out why my user is 'broken' now, will post back...

Thanks Alvin. But shouldn't the 'Local System' account have enough privileges to run the job?

http://msdn.microsoft.com/en-us/library/ms143504.aspx

I changed the job owner to 'sa' (from my domain account) and it...

I found that the email account that I was using to try and send email was not configured properly. Found this out by talking to my email admin. ...

Could be a bug:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6f143ca9-d08c-4028-9fef-58ae62ae5fc6

I'm going to follow up with Microsoft.

Thanks Jeff. But as I stated, that area was changed to email me and I've yet to see any email. Also, when I look at the properties of...