Well, we have 56 databases on that server.  I would have follow Bill's advice but I don't own the server.  The person who owns the server expects jobs to be setup...

Thank you for your reply. 

The server is a shared server, so there are quite a few databases.  Setting up separate maintenance plan for each database is not feasible.

I am not...

Hi,

I need a record of who log in/out of the database, but didn't know how to do it, so I used SQL Profiler, but when I save the trace files...

Mike,

Thanks for the tips.  The dbs and trans. logs get backup ok now.

When the transaction log files get backup, don't they suppose to delete the old inactive transactions?  Or do...

I created backup plan (using Enterprise Manager) for several servers, some of them worked some of them didn't .  For those didn't do the backup, the error I got was...