CirquedeSQLeil (4/2/2010)

---

George, I think you would be ok with RedGate Backup. It's not like most other backup tools for SQL server. It integrates nicely with SQL server and...

sorry Chad getting completely off subject but I know these companies pick up on internet entries so I will post this here:

Hyperbac - please don't move away from the ease...

TheSQLGuru (4/2/2010)

---

1)

3) consider getting Hyperbac. <....snip........>I even don't have to worry about promoting it here on SQLServerCentral any more since Red-Gate just bought them! :w00t:

Disclaimer: I...

well you already had one problem and had to post for a solution 🙂

where is your resource database? If its not in the same location as master your next attempt...

you can install standard and enterprise together under one license, however I would expect that would have to be an enterprise license.

mirroring - with standard edition you can only do...

do you try a shrink with truncateonly first? you might get lucky and remove a chunk with no effort that way.

I wonder if a reindex before the shrink (I know...

the question says 'select ALL that apply' so should...

Alvin Ramard (4/1/2010)

---

FYI, here's the suggestion I had sent to Steve for today's QOD:

[font="Verdana"]The undocumented command DBCC TimeWarp 'VerifyOnly'

(Select all that apply)

A - Returns the same results with SQL 2008...

got caught by the 'quoting whilst new post pops up' trick

CirquedeSQLeil (4/1/2010)

---

JF1081 (4/1/2010)

---

I googled it and the first item returned was a SQL server central thread. The link took me to the middle of the thread and I thought...

If you are thinking of using this as a method to move to another computer, give up now. You are just at the start of the problems you are going...

It depends.............

SanjayAttray (3/31/2010)

---

Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D

Even tried to google it and found nothing much. ...

its in BOL somewhere.

From memory its 2 to the power of 15 or 32,768, i.e the value is held in a two byte field

Will that be enough connections for you?...

Paul White NZ (3/31/2010)

---

Lynn Pettis (3/31/2010)

---

But I also think it would be nice if there was an encryption option when doing backup/restore operations as well. I also think that...