I don't think you can copy any ndf in there. Was there data on the file?

you could try restoring the backup to a new db, then shutting it down and...

I've had lots of phone interviews, typically with HR or a manager, mostly to check if we are likely a match for each other. I guess it's partially personality, partially...

You definitely want advice, but you can't necessarily expect it to be the best for your system. Asking for someone else how to do something on a forum/twitter/etc., doesn't absolve...

You first need to read this about transaction logs: . A full backup does not clear your transaction log. You need to run a log backup, not a full backup....

What's not working properly? when you reboot it is set to start 3 days from the boot?

The log backup cannot let the transactions be removed until they move to the distributor and subscriber. I'm not sure which log you're talking about, but if you have log...

Wow, that's a tough one. I'd try to turn the LUN back on. If that doesn't work, is the database suspect? I might try to drop the file and add...

I'd suggest a rebuild to get into a known state, and then see what happens.

That's a great link. I'll have to add it in the newsletter. Thanks!

When I was on the East Coast, we made contingencies, but our company could actually survive for a day or two without the systems. So it was harder to convince...

Triggers fire, but depending on what you've coded, perhaps you're missing something. Showing the details will help us decode it.

also, have you checked the code that is used in the...

I believe you can nest 32 transactions. Most other nesting options seem to have stack of 32 (http://msdn.microsoft.com/en-us/library/ms143432%28SQL.90%29.aspx)

What you wrote doesn't make sense to us. We can't see the data, and we can't see the rules or results you need. Based on your first post, I'm not...

If you shrink after rebuilding, you can re-fragment the indexes. When the shrink moves pages, it puts them where it can, so you easily can undo your rebuilding work.

If you...

The ALTER INDEX command is used: http://msdn.microsoft.com/en-us/library/ms188388%28SQL.90%29.aspx

You can also use a maintenance plan to do this. Create a new one that does it on a weekly basis. Or check scripts...