There are a zillion other threads on this site relating to this very topic (the search feature here works wonders)! Any number of things can cause the log file to...

Something has changed if it ran for years without issue. My guess is your source file. The error is pretty self-explanatory as it states your column delimiter is missing (what...

Donn, the beauty of a maintenance plan is that you can select all non-system databases. This will grab any database, new or not, and add them to the backup job....

Actually, while I agree with your comments, especially about knowing what is causing the growth and the expense of growing (and shrinking), the tasks can be performed as simply as..

BACKUP...

This is straight from BOL. I apologize if it looks basic but it should be a very simple task. The assumption with this script is that you have one data...

This is how I do it. See if this works (it's pretty staright forward). In EM, right-click and create database. On the new database, right-click->All Tasks->Restore. On the restore pane,...

Seems to be a VERY popular subject lately! Check this other thread going on. It should help. Re-read Steve's comments in the first link after you've accomplished what you want...

This works for me. I'm running SQL 2K, sp4. Perhaps the missing GO statement at the bottom?? And notice that I've commented out the were clause. If it wraps on...

This is kind of primitive but it works. It'll retrieve all non-system databases on a server (DB_ID> 4). The where clause seems to fit you condition of only non-autogrow databases...

Post the script and we'll absolutely help.

Under the maintenance plan, "Remove Files older than", set whatever works for you (1 day, 1 week, etc.). A maintenance plan should be creating a separate file with a date/time...

I agree with John, use the resources, learn a little and if you have specific issues, post them. Many of us will gladly help...but try and help yourself first. Having...

So on a restart, you didn't see a continuation of the rollback prior to the database being brought on line? That would be very odd, possible I guess, but strange....

Check out this link:

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

I personally like to have all my maintenance done prior to my backups. If I come in the next day and we have any issue, if I restore to my...