Has the key been copied to the other database?

As Paul mentioned, if the headers are corrupted, there is no way to attach it. They saying goes:

Good resume

Good backup

You only need one.

You can check sp_who2 to look for blocking, check the CPU as another query might be taking up resources. If the server was recently restarted, the first query can be...

The reason that everyone recommends backing up locally is that the backup process is similar to UDP on the network. It is optimized for speed and sends pages out as...

SQL Server is a server service, not a program like Access. It needs to be running for a client to connect. For both your questions, you really need to look...

I guess I meant it's harder to say I worked 10 hours at home and took Friday off instead of 8 hours. It's more that you just have to get...

Ah, I haven't done 4 days a week at home. I work 7 days a week, probably 50-51 weeks a year now. Probably too much if you ask my wife.

I...

Good to hear some of you getting away. And nice one, blandry. We went on a couple vacations and the kids struggled without the xbox/ipod for a day, then they...

What's the volume of activity? I'd lean towards storing a balance for a couple reasons

- space is cheap

- Unless this is a really busy app, the calculations shouldn't impact performance.

-...

Doh! Eyes getting old. Can't believe I missed that.

It is possible that there wasn't sufficient free space to make a big difference in the fragmentation, or that the SAN somehow interferes.

Which product did you use? The built in...

Good advice above. Best reason to do system dbs? The server crashes and you need to restore elsewhere. You need master and potentially msdb to do this.

If you do that,...

Wow, no idea what would be wrong. I've never seen the order of tables matter, and I'm not sure why you get different results.

Are these in the same SSMS window?...

Randy,

Thanks for the links and I'll check them out!

good point and I don't disagree that nuclear has dangers. However chernobyl was amazingly poorly handled. Bad design, things switched off, it's incredible they didn't have more accidents.

I don't think...