Attach Database Problem

Question

Attach Database Problem

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Andreas AJV SSC Eights! Points: 800 More actions · Answer 1

Indeed Ramma, a difficult situation , but I was just wondering if u had a network problem.... but I suppose you may know (your problem) better than me...

I hope now everything works fine.

------------
When you 've got a hammer, everything starts to look like a nail...

SQLBill SSC Guru Points: 51440 More actions · Answer 2

Rama,

Sometimes when a database is suspect, just detaching it and attaching it will fix it.

-SQLBill

devaraya Default port Points: 1455 More actions · Answer 3

Hi Bill,

I did't try this one. I did resetstatus on suspected databases. Thank you bill i learned a new thing from you.

I got one more doubt on suspect state. I kept some databases in offline mode, after two days the status turned to status/offline. What is this? and can i keep the db's offline forever?

Ramaa

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Yes, you can keep them offline forever. You just won't be able to use them. Were you using Enterprise Manager to view the status? If so, EM doesn't 'refresh' very often. When you make a change, you need to refresh EM yourself - so they probably went to offline quickly, but just didn't show it on the screen.

-SQLBill

devaraya Default port Points: 1455 More actions · Answer 5

devaraya

Default port

Points: 1455

April 12, 2006 at 12:05 am

#632006

Hi Bill,

Thank you very much

Ramaa