GT-897544 (2/18/2010)

---

And i also feel i should keep away from this Blog, as when ever i replied to question looks like other DBA's are not happy.

Time to hit the...

Would like to write one, just not too sure about what to write. Some people can write with ease,...

Glad to hear that you had good backups and could get the databases up and running on another server.

This is what Google Transalte came up with, is it close to what you are asking?

I need to migrate a database to another server, and users must take the database

To...

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

GilaMonster (2/18/2010)

---

It's not.

Cleanly shutdown is indicated by...

GilaMonster (2/18/2010)

---

Yes, both the price and the download limit. Have edited to make that clearer.

In case it's not obvious, that's not aimed at the individual...

GilaMonster (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

GilaMonster (2/18/2010)

---

Pigeon or smoke signal please. Swallows exceed the internet speed limit in this...

RBarryYoung (2/18/2010)

---

These last few lines of your dynamic query:

...

And (tEx.BoatID = 0 Or 0 Is Null)

And (tEx.EventID = 0 Or 0 Is Null)

And (tPh.Weight >= Or Is Null)

And...

Bow out now. I'm standing in the corner at the moment... 😉

sorry, ma'am. I'll just go stand in the corner now.

GilaMonster (2/18/2010)

---

Pigeon or smoke signal please. Swallows exceed the internet speed limit in this part of the...

GT-897544 (2/18/2010)

---

If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.

1) Do you have clean backups for these databases?

2) If...

CirquedeSQLeil (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

I just wish the OP would check/post what is in the error logs. That could help answer many questions and provide him with some valuable responses...

CirquedeSQLeil (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

Should we be working on the SSIS packages now to extract the data from the databases? 😛

[ apologies ]

I'm sorry for the sarcastic comments in the...

GT-897544 (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL...