Viewing 15 posts - 586 through 600 (of 1,319 total)
Roy Ernest (6/19/2009)
Paul White (6/19/2009)
Kit G (6/19/2009)
Kermit the Frog?Win.
lol... You both cracked me up.... 😀
Jabba the Hutt?
-- You can't be late until you show up.
June 19, 2009 at 9:04 am
george sibbald (6/18/2009)
sarvesh singh (6/18/2009)
Managed to get a planned downtime to restart the sql server.
Also i added the estimate only clause to...
-- You can't be late until you show up.
June 19, 2009 at 6:53 am
Luke L (6/19/2009)
Please go boil your head
Quote of the day/week/month/year?
-- You can't be late until you show up.
June 19, 2009 at 6:48 am
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.
-- You can't be late until you show up.
June 16, 2009 at 12:54 pm
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...
-- You can't be late until you show up.
June 16, 2009 at 12:50 pm
Kit G (6/16/2009)
Cubs? I don't follow football... or it is baseball? :hehe:
Sometimes we're not sure! 😛
-- You can't be late until you show up.
June 16, 2009 at 7:19 am
RBarryYoung (6/16/2009)
-- You can't be late until you show up.
June 16, 2009 at 6:12 am
ps (6/15/2009)
Antero Ruiz (6/15/2009)
-- You can't be late until you show up.
June 15, 2009 at 2:17 pm
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...
-- You can't be late until you show up.
June 15, 2009 at 7:14 am
Roy Ernest (6/12/2009)
oops.... Sorry... vary and wary...
My apologies to you, just yanking your chain. It's Friday and I'm feeling fine!
Roy Ernest (6/12/2009)
-- You can't be late until you show up.
June 12, 2009 at 8:53 am
Roy Ernest (6/12/2009)
I am a bit vary of that idea...
Personally, I'd be a bit "wary"...;-) What's that old saying? "Don't vary, be happy"
-- You can't be late until you show up.
June 12, 2009 at 6:35 am
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...
-- You can't be late until you show up.
June 10, 2009 at 10:05 am
Tom Brown (6/10/2009)
Deleting data does not free up the space on the hard-disk.You need to shrink the files
see DBCC SHRINKFILE in BoL
Don't shrink the files unless you're out of disk...
-- You can't be late until you show up.
June 10, 2009 at 7:05 am
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/
-- You can't be late until you show up.
June 10, 2009 at 6:38 am
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...
-- You can't be late until you show up.
June 9, 2009 at 8:58 am
Viewing 15 posts - 586 through 600 (of 1,319 total)