Greg Edwards-268690 (1/31/2012)

---

Brandie Tarvin (1/31/2012)

---

SQLRNNR (1/31/2012)

---

Greg Edwards-268690 (1/31/2012)

---

Shows what happens when...

DR and HA are NOT the same thing, nor should they be confused as such. Replication is an acceptable solution for High Availability, but it will not completely recover your...

I did assume that SQL Express itself was installed. Whoops. Bad Brandie.

SQLRNNR (1/31/2012)

---

Greg Edwards-268690 (1/31/2012)

---

Shows what happens when I think - other...

I'm not sure what you mean by empty. Could you clarify?

Ouch. Sounds like you have SDLC issues.

Is there a reason you can't use the Information_Schema and sys.objects tables / catalog views to do the checking with each addition / change...

Find the installation logs and verify that SQL Express installed correctly. Also, check your services to make sure that SQL Server service and SQL Agent Service are both running. You...

Use the Information_Schema catalog views to spit out a table / column list. Adjust the below code as necessary:

SELECT Table_Catalog, Table_Schema, Table_Name, Column_Name, Is_Nullable,

Column_Default, Data_Type, Character_Maximum_Length as ChLen,

numeric_Precision,...

electricity

SQLKnowItAll (1/27/2012)

---

Brandie Tarvin (1/27/2012)

---

SQLKnowItAll (1/27/2012)

---

If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending...

SQLKnowItAll (1/27/2012)

---

If one of my applications cannot connect to a db for any reason, I need to have the best way to handle that situation. Depending on the disaster...

Jared,

Actually, I'm approaching this from the POV of someone who did DR & BC design at a previous employer far far before I ever became a DBA.

It's obvious to...

Reasons why I disagree with Replication as a DR solution.

1) Latency. Depending on your replication setup, you could have more latency in it than in your normal database backups. Which...

I'm reaching, but ... Does this help? http://guomingli.blogspot.com/2010/03/ole-db-provider-sqlncli-for-linked.html

Anybody here backup with BizTalk?

http://www.sqlservercentral.com/Forums/Topic1242925-391-1.aspx#bm1242974