There should be more details in a text file. Check the maintenance plans for logging and the location.

My guess is that certain server level permissions cannot be trasnferred this way. Perhaps this explains it?

http://support.microsoft.com/kb/913422

Is this a user and not a login?

you have to do what Greg suggested.

Maybe you could give us more details about what this is?

It depends on whether or not the data in the filegroup changed and how that affects the rest of the database. It's possible to restore the file and cause issues...

If you run a transaction log backup, the inactive portion is truncated and reused. Maintenance plan or not.

Good advice above from Tom.

I think backups and security are most important, but it's good to get the other information listed above.

Or the server is down. This can be a network or permissions error.

Follow Matt's advice. Dont' delete anything.

Can you connect with iqsl and do a dbcc opentran in tempdb?

If you have queries with lots of static information, you can replicate to other instances on other servers and potentialy gain some performance, but your application has to support this.

You...

I'd follow the advice above, especially Robert's, but understand that you can only get back to the MDF file. You can't remove that one since it has system information in...

You are welcome and let me tell you that I learn from many of you still. I appreciate you coming, more than just because it pays the bills. I enjoy...

That's strange. I wonder what it's doing as well. Profiler help at all or does it just show xp_sqlmaint?

Mattie,

You create a unique index when you set a PK. Setting the PK is the equivalent, but it does help you pass along information to others and even yourself about...

First, forget about Access. SQL Server is a server, like a mail server (Exchange) and so there isn't "a user" or a default.

It doesn't matter if SQL is on the...