JaffaCakes

Schadenfreude-Mei (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls...

k.subramanyam1017 (5/21/2012)

---

Hi friend,

Thanks for u r experience given answers but one thing what is the third question answer that is -3!(like year gap)pls tell...

You CANNOT create mirroring on the same instance, it has to be different instances

2005...

what commands did you use to move the system databases? also is it SQL 2000/2005/2008/2008R2

to add on from John's comment

or restore the db to a different name and use something like SQL Compare to see what the vendor has changed

Robin Sasson (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friends,

could u please any one tell me the these questions

1) what is your company file architecture and how much data u r...

Care to share the solution incase someone else has the same issue?

anti virus blocking mass mail worms? or databasemail.exe?

firewall blocking port 25?

authentication issues?

SMTP server not set to allow you to send SMTP mail? (in exchange, you need to add the...

data types?

error messages?

what expressions have you tried so far?

Thanks Drew, learn something new every day.

No, as an index rebuild is a fully logged operation so it logs the same amount in Full or Bulk-Logged so there is no difference

Unsure if you will see the alter index, I would of said you would see restore database or restore log as its restoring the log, it just so happens that...

secondary server is generally in norecovery mode so no users, so no load on the database so can usually do things quicker as its not serving user requests