I was under the impression that the non-administrative account is the account that the job runs under, rather than the account attempting to see the job details, and that you...

I second what Nicholas said.  Third party solutions in this type of scenario are probably not a good idea.

Steve

Are the job and schedule both enabled?  I tried changing a job on my test server to a non-administrative loginid, and it still showed the schedule properly.  When I disabled...

Progressboy,

I think there is a basic misunderstanding about the log file here.  In Simple Recovery mode, SQL does NOT truncate the log when it fills up.  In fact a full log...

Could it be that you just need to refresh the screen?  EM is notorious for not showing the most current information, and must be manually refreshed.  Right click on the window...

Don't give up.  I'm sure there is a way to do this with a set based query, I just can't get my brain wrapped around it just now (too close...

If you're still unable to start SQL (due to the corrupt master), have a look at "Rebuild Master" in Books Online.  There is a utility that will rebuild master to...

If you're just going to delete it after it finishes restoring, just cancel the restoration, leaving the database in "Loading" status, then delete it.  No need to allow the restore...

Deeps, If your log continues to grow when you are doing 4 transaction log backups per day, increase the frequency of your log backups until they quit growing.  4 transaction...

I think the correct answer would be "It depends".  Have a look at "Controlling Transactions" in Books Online.

Steve

Arnold,

I found the other thread.  It was lurking right next to this one.

While a weekly full backup, daily diffs, and hourly tlog is an option, if possible, I would opt...

Arnold,

If the answer is not already in this thread, could you please be more specific about the problem that you are experiencing?  I don't know how to help because I...

I have livestock.  one dog, 4 lizards, 5 fish, and 2 mice (the mice were actually to be dinner for my daughter's snake, but the snake moved to her science...

I don't know why, but I see that problem from time to time as well.  You can also see it when you register a new server in Enterprise Manager.  The...

Well, daily, and some may wish that I was silent.  Steve, I really enjoy the editorials.  Adds a little variety to the constant onslaught of SQL Server!!!!  Good luck with...