Roy, did that blog help?

Also, where are the errors occurring? First connection, randomly while people are working? Do you get any errors from the local connections like from Agent?

If this is a regular problem, you need to buy more space. It's that simple.

Mapping shared drives will work...sometimes. However it likely will fail when your database fails, and then...

Michael Lysons (5/8/2009)

---

Good grief, sweeping generalisation about developers there, Steve. Seems to me that if a developer is implementing incorrect indexes etc, then it's actually the DBAs fault for...

Blinkering?!?! Blimey, major, Great Scott, you bloody well confused me!

throw him a pork chop, Bob!

I'm not sure what his problem is either. I think he's written a sh**ty application and now wants to overengineer the SQL code to back...

To move just tables in the same db, you need to create a new filegroup on that new drive. Then rebuild the clustered index on that filegroup, and the data...

First, why shrink the log? If you load again tomorrow and it grows, what have you accomplished? Nothing.

Your strategy of backing up the log every hour is sound. You should...

I tend to agree on the restore. It's not a hard thing to do if the db was running in SQL 2005. Worst case, build a DTS/SSIS package into the...

Kurt,

I've tended to agree. I never missed Intellisense in T-SQL, and never wanted it, but I have used it and liked it in VS. I think part of that is...

SQL will let you know if you're out of order. Typically you're restoring by times anyway.

Be sure that you always restore with NORECOVERY. You can always bring it online later,...

Well

, I think leading commands are

, well

, easier to read

:hehe:

No difference. This forum software allows for multi-threaded posts (replying to a specific post), but we have removed that. All discussions are single threaded to avoid confusion.

There must be some process that is changing the mode. You might need to run a trace to try and catch this, or run a script that checks it every...

Please don't cross post. Reply here: http://www.sqlservercentral.com/Forums/Topic451573-150-1.aspx#bm712110

Feeling hungry, pork chops sound good this am 😉