Viewing 15 posts - 6,256 through 6,270 (of 9,715 total)
Transactions while DB is in SIMPLE recovery mode.
March 21, 2011 at 8:46 am
Try searching without the @ on his handle.
March 21, 2011 at 7:35 am
Glad we could help.
March 21, 2011 at 4:38 am
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.
Ever get the feeling you're being followed?
@=)
And I took the opportunity to follow Gail and Lynn...
March 21, 2011 at 4:36 am
stebennettsjb, let me ask these questions.
Who's spending the money to get these tools? And what's the budget?
And what else would you be doing if you had these tools to "take...
March 18, 2011 at 12:51 pm
Your post title is correct. This is a simple task.
So why did you post it?
March 18, 2011 at 12:45 pm
Gail Shaw recommended that I install regular 2k8 first, then R2 second, just to be on the safe side. I don't know if there are issues, but I'd take her...
March 18, 2011 at 11:44 am
PROGRESS!
Found the proper log under the directory I set as my default database location.
...\R2\MSSQL10_50.SQL2K8_R2\MSSQL\Log
"SQL Server 2008 SQLServer Error: 65535" comes up with Google links, the first of which is this:
I'll...
March 18, 2011 at 11:42 am
HowardW (3/18/2011)
What does the event viewer message say?
The Application event says exactly what I posted above, with an event ID of 103, Task Category: Service Control, Keywords: Classic and Detail...
March 18, 2011 at 11:33 am
Steve Jones - SSC Editor (3/18/2011)
Or check the event logs, usually the security one.
Not seeing a whole lot under security, except a few messages (about the first time I tried)...
March 18, 2011 at 11:24 am
Thanks, Howard. I have both 2k5 and 2k8 R2 installed on my laptop and I can only find one version of that file, exactly where you said it was. However,...
March 18, 2011 at 11:09 am
This is probably a little late for you, but I really wouldn't have used a loop for this delete. I'd have gone with the straight delete, but changed the Archive...
March 18, 2011 at 10:58 am
Daniel Bowlin (3/18/2011)
I'm not really paranoid, but people are out to get me. 😀
Just because I'm paranoid doesn't mean people aren't out to get me.
March 18, 2011 at 6:50 am
kd11 (3/17/2011)
The Plain has been created via GUI (Management Studio)
FYI: It's "plan", not plain. There's no "i" in the word.
The GUI won't help you with this. None of the available...
March 18, 2011 at 5:44 am
Viewing 15 posts - 6,256 through 6,270 (of 9,715 total)