And then he recommends a DBCC with REPAIR_ALLOW_DATA_LOSS. Only as a completely last resort, say I discovered that my backups were corrupt (or worse, never done).

GT-897544 (2/16/2010)

---

sqldba551 (2/16/2010)

---

Hi,

As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT...

replace(convert(varchar, columnname , 6),' ','-')

Does this help?

Then, after a quick "conversation" with Gail, and not knowing what errors occurred to put the databases in suspect mode, he recommends putting them in Emergency mode then extract the...

lmu92 (2/16/2010)

---

Lynn Pettis (2/16/2010)

---

Easy, the cause is the following lines:

SET @Jun30Date = CAST('06/30/' + cast(year(@Report_From) as varchar(4)) as datetime)

...

RBarryYoung (2/16/2010)

---

Just knowing that I am helping someone is what makes it all worthwhile.

(if that doesn't make sense, then note closely the dates & times in the thread above, and...

Okay, Gail is in rare form here. Or should I say, I'm glad I'm not the one who is on her bad side today.

How about a different rant. Don't you get tired of answers that really don't help?

Such as this one and this one.

Servers are not principal, databases are. Database Mirroring is at the DATABASE level,...

NEI, Not Enough Information.

Have you checked the SQL Server logs for errors? If so, what errors were reported?

As many times as we have run into questions asked in the wrong forum, I did ask the OP which he is working with, SQL Server 7/2000 or SQL Server...

Easy, the cause is the following lines:

SET @Jun30Date = CAST('06/30/' + cast(year(@Report_From) as varchar(4)) as datetime)

...

varma1412-1092791 (2/15/2010)

---

Hi,

It would be great if someone can help me out.

I have a table which has a column with list of Instances in it. By calling this table I have...

Elliott W (2/16/2010)

---

I completely understand, because of the title I never looked at the group it was in.. But I stand by my recommend and the link posted.. ...

SuzDBA (2/16/2010)

---

For this post let's assume I have 2 servers: Server A and Server B

Server A will have 3 Databases: DB1, DB2, DB3

Server B will have 3 Databases:...