GilaMonster (6/23/2011)

---

In this situation, there is NO way to take a log backup (the log chain is broken) so the best you can do is restore full, diff and any...

lrutkowski (6/23/2011)

---

I was always taught to use the create table, insert method. not because it is faster, but because it blocks the sysobjects while the table is being created...

Any comments on my wild guess Gail?

HTH. very common misconseption about that ermm "feature".

The only real use I've seen of it is for myself when I need to test...

Wow you learn something new everyday!

Do you still have the temp table laying around?

You could try all the usual tricks (drop / rebuild clustered index, lob compaction on, etc).

If that...

Caveat 6-7-8-9.

Bad data

Connection being destroyed on super severe errors

management makes wrong decision based on bad data

Need to find another job because of the...

.... and what's the state of the db? Does it at least show in the list of databases? If it does in any fashion at think you have...

P.S. datalenght will give you the correct size with trailing spaces and datatype. This is what I'd use to make sure I have the correct value there.

matt.newman (6/23/2011)

---

Oops... len * 2... 2 bytes per character.

Thanks for the catch! Looks like the issue then is most definitely recurring! I will have to look into turning snapshot...

Switch to datalength instead of len so that it includes trailing spaces.

Also why the *8 / 1024? It's the 8 that I don't understand.

sp_spaceused returns kbs so to...

I've delete that job but I swear I've already done something similar to this :

MOVE c:\backups\*.bak D:\backups[\].

I'm 99.9% sure that you don't need a destination name for the file.

<disclaimer : start testing mode>

Here's what I'd try if I were you :

Rename the...

I don't have all the info I asked for but this is where I was going with this >>>

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

Try doing a dir in both folders. That should show you access denied error.

Lowell (6/23/2011)

---

gotcha, so in a disaster recovery scenario like that, where the mdf was damaged/lost, you would not be able to do a tail backup...

all you can do is restore...