Is this a test or homework question? It doesn't sound like a production issue.

We are happy to help you figure things out, but please give us some idea that you've...

When you use TRUNCATE_ONLY, no log backup is performed. The log file is just truncated.

You should not be using TRUNCATE_ONLY in general. Just run backup log with the disk path.

http://msdn2.microsoft.com/en-us/library/ms186865.aspx

I think I remember seeing this as well. It looks for specific extensions. I thought this changed in SP2, have you applied that?

Is this a homework or test question?

Perhaps you can post what you think should happen and we can help guide you.

Sounds like a naming issue. Can you restore the backup without creating a database first?

Does another user have the file open on their desktop?

Surprisingly, we have more important things. I noticed it and a few people have pointed it out, but there's not really any other choice that makes sense, so hopefully it's...

I see the article. What browser are you using? Do you see what's attached below?

You want this stuff written to the log. It is how you can ensure that there are no integrity issues, like if the power dropped in the middle of your...

I haven't. HAve you checked the security on the files created each way?

I think I noticed #2 as a bug. The task actually builds the code at runtime and if you delete the databases, you can't undo this. I believe you need...

I should have remembered that. Good idea, George!

If you are planning on using SQL Mail, I'm not sure the transaction log comes into effect. The log is used to record changes to data, not mailings, alerts, or...

The job doesn't contain the steps for the plan. The job just runs a "package" that's set up with the plan. The job is just a trigger for the maintenance...

Thanks for the update.

Is this strictly a security issue? I'm wondering why someone can be a sysadmin in one db and not another? Are you a sysadmin in the other...