Log shipping can pull from the secondary to acquire log files on a UNC path, which presumably will remain active when your primary "dies". So you should be able...

Ozzmodiar (2/16/2015)

---

It's been a long while since I've used log shipping to be honest; I wasn't aware that it was a 2-way process.

Assuming I went forward with log shipping, have...

Transaction log shipping. From your description that will be sufficient for your needs and is VERY simple!

Ford Fairlane (2/15/2015)

---

Hi all,

I am looking for solutions to a tricky situation.

I have a database in say Datacenter A. Probably about 300GB in size. It is running on SQL Server...

GilaMonster (2/13/2015)

---

TheSQLGuru (2/12/2015)

---

In about 20 years of working with SQL Server, mostly as a consultant at a wide variety of clients I have come across only a few systems that...

In about 20 years of working with SQL Server, mostly as a consultant at a wide variety of clients I have come across only a few systems that were CPU...

Sorry, I cannot guide you on this. It is WAY beyond a forum post, and in fact would be tens of hours of consulting at a minimum. Honestly...

Oh, beware of unindexed FK type fields. Doing iterative table scans to find things can be ugly. 🙂 Not sure if that applies here but it is general...

1) That wasn't an "attached" query plan. Help me out here please. 🙂

2) Are the data types all proper?? Conversions can kill!

3) Maybe it would be best to DROP...

WHY do you want to implement Always On?? There are SOOO many ways you can mess that up, and lots of caveats, provisos, limitations, gotchas, etc. I have...

I have been doing SQL Server for about 20 years, most of that as a consultant at all kinds of clients. I can count on precisely zero fingers the...

Please attach the estimated query plan. My guess is index deletes are in play with the bad plan. There may be ways to assist with that.

Floats are not precise values, so I wonder if that isn't part or all of the issue.

Can you convert them to varchar(50) or something and do a string...

Make it easy for us to help you by creating tables, populating them with data (you could use Lowells work for that?) and then showing expected output from your description...

gaojia2004 (2/9/2015)

---

TheSQLGuru (2/4/2015)

---

Until you mentioned it I had never heard of Zabbix. That isn't a good sign for you BTW, as I have been dealing with SQL Server for...