Jabba the Hutt?

george sibbald (6/18/2009)

---

sarvesh singh (6/18/2009)

---

Thank you all again for ur responses;

Managed to get a planned downtime to restart the sql server.

Also i added the estimate only clause to...

Quote of the day/week/month/year?

If you have the .mdf and .ldf you can simply attach the database, no restore involved. If it's truly a .bak, then it's restore database.

Larger queries may also try and resolve themselves in tempdb. The reality is, what's running on the server? And then, whay are your resources so limited? You should have enough...

Sometimes we're not sure! 😛

RBarryYoung (6/16/2009)

---

Most trolls suffer from some kind of brain damage or other mental disability. Or both. And this makes them funny when they try to act like...

ps (6/15/2009)

---

Antero Ruiz (6/15/2009)

---

We can't run a full weekly backup because we don't have enough storage for the gigantic backup file, besides, when it was just 10TB we tried to...

Dang, gone for 48 hours, missed 50+ posts and one "ubernoob" (superboob?).

Gail, please don't think about not posting because of one jerk. You're better than that and I know...

My apologies to you, just yanking your chain. It's Friday and I'm feeling fine!

Roy Ernest (6/12/2009)

---

I need a good spell checker that can read...

Personally, I'd be a bit "wary"...;-) What's that old saying? "Don't vary, be happy"

I'm not saying never do it as one-off events do occur. The point is, and I should've stated it in my previous post, if you shrink the data file (not...

Don't shrink the files unless you're out of disk...

To migrate logins see the link below for a nice little stored proc. I just did what you're attempting to do and this worked perfectly.

http://support.microsoft.com/kb/246133/

Correct. As I stated, it'll also allow you to practice point in time recovery. You can also run RESTORE VERIFYONLY (see BOL) against the backup file which will also validate...