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...

I'd send over an ANSI guide to the students, get them to change. You can take some of their examples, explain how you change their queries to a more standard...

I'm not sure there is. However if you (or someone else) wants to write an article to explain it, let me know!

Not I unless you count volumes of family pictures.

I do know a few IT folks, programmers, that are into photography.