Viewing 15 posts - 41,716 through 41,730 (of 49,562 total)
Jeff Moden (1/15/2009)
January 15, 2009 at 7:25 am
So the drive was accessible when SQL started, but something happened a little later. Can you check the windows event log around the same time as the latch errors started?...
January 15, 2009 at 7:14 am
GSquared (1/15/2009)
Sounds like quite a nice collection. All I have is handguns, and none of them are particularly pretty (functional, but not quite so aesthetic).
Grant Fritchey (1/15/2009)
January 15, 2009 at 6:55 am
Grant Fritchey (1/15/2009)
For example, oh Gail, how many swords in your house?
Only one at the moment. I'm considering buying a basket-hilt rapier (local weapons shop has a nice ornamental...
January 15, 2009 at 6:41 am
Kent Waldrop (1/15/2009)
I would say that biggest source of the problems that I've seen over the years are design problems.
Agreed. I'm in the middle of a wonderful one now.
Rather...
January 15, 2009 at 6:34 am
-- Cranfield (1/15/2009)
I was thinking of renaming the files, dropping the database and then atttempting to attach the files.
No! Absolutely not. If you do that, there's a good chance...
January 15, 2009 at 6:21 am
Ol'SureHand (1/15/2009)
January 15, 2009 at 6:20 am
arup_kc (1/15/2009)
Hi Gail,This is actualy a question, which I have faced in an interview.
I thought as much.
Just note with the solutions above, there's no guarantee of order. It...
January 15, 2009 at 6:16 am
Please read through this - Managing Transaction Logs[/url]
I just noticed that you're backing up the log with NO_TRUNCATE. Why?
January 15, 2009 at 4:35 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Why do you want to concatenate the values?...
January 15, 2009 at 4:28 am
Google tells me that Operating System error 21 is "The device is not ready." It's saying that the file can't be accessed at all, not that a couple sectors are...
January 15, 2009 at 4:26 am
Take the database into single user mode. That means that no one can access it for the duration of the fix. You may want to shut down sharepoint (if that's...
January 15, 2009 at 3:50 am
Colum.Whelan (1/15/2009)
redgate SQL Log rescue, will show you all the inserts updates and deletes
From redGate's site:
Please note that SQL Log Rescue does not support 64-bit versions of SQL Server or...
January 15, 2009 at 3:48 am
rodjkidd (1/15/2009)
Wow three pages of replies since I went home last night - I must be in the wrong time zone...
Same here.
I am amazed by the patience of some...
January 15, 2009 at 3:26 am
How much will you lose by restoring the backup? This is repairable, but you're going to lose what's probably a document. Not easy to say which one.
January 15, 2009 at 3:22 am
Viewing 15 posts - 41,716 through 41,730 (of 49,562 total)