Well, add it up. You have 2gb of data plus 13gb of free space:

2+13 = 15

Which means that it needs to allocate 15gb, give or take, to recreate the existing...

I'm not entirely sure I understand the question, but you could use SSIS packages, as suggested, to move the data on a regular basis, or you could set up replication...

It sounds like your log file is of sufficient size. As was noted, you may have a log backup process running. Your system might also be in simple recovery mode,...

The upgrade advisor functions, I know because I've used it on multiple machines. So the problem is either your installation or your OS. Clean it up, download a new copy,...

That's a tough one, it really depends on a lot of factors, but a rollback frequently takes about as long as the orginal transaction. Sometimes it takes less time, and...

I'm 100% with Steve. Backup locally, to a seperate drive from any logs or data, and then copy to tape or network shares as appropriate.

In our case, we're on a...

Did the query itself complete? If not, it's still restoring.

Jack Corbett (4/19/2010)

---

Don't usually say this, but going to be in meetings for a few days, so I'll be even less active than I have been recently. Also have...

jabadwy (4/19/2010)

---

I was looking in forums and came across this post.

Here Adi has made a point about size of nc index in comparison to clustered....which makes some sense to...

To see what's running you go to sysjobactivity in the msdb database.

Steve Jones - Editor (4/18/2010)

---

I don't...

I usually is... or maybe all those millions I pay for exclusive rights to use it is the thing?

My understanding is it was supposed to be in April. Last year I got...

Steve Jones - Editor (4/17/2010)

---

Yeah, those dates from Jason sound right. We upgraded from 4.2 to 6.0 to start a dev project, and then about 6 months in 6.5 came...

WayneS (4/17/2010)

---

Grant Fritchey (4/17/2010)

---

WayneS (4/17/2010)

---

Steve,...