Please start a new thread instead of posting to one that is a year old.

GilaMonster (5/16/2014)

---

Honestly, seriously, recommend to your client (and your company) that they look for a DB specialist to help them with their DR and that they let you work on...

Looks like it took me just a bit longer than Robert and Gail to craft my "you probably shouldn't be doing this work (alone)" reply.

OP: You just had...

OP: Sorry to be blunt but I have to ask: are you SURE that you are qualified to be setting up DR for this client? You are doing...

Are you sure you have an "Active/Passive" failover cluster service or application in place (i.e. SQL Server Failover Cluster Instance et al) since you say you DON'T have Always On...

1) Check Connect to see if there are any similar issues posted there.

2) I would not expect this to be improved by Microsoft.

3) This could also be because of your...

Post up a screen shot of the tool you are using that you described in the first post.

As for Always On, see here for DMVs you can use to get...

1) You cannot have a PK on a NULLable column. Fix the column attributes or do something different.

2) Partitioning is a VERY COMPLEX subsystem! You are...

If you screw something up when dealing with HA/DR the company can lose a tremendous amount of revenue (and even wind up going out of business). I have a...

Adding to what Grant said, there are some HORRIBLY bad design and coding choices here. Some of them you will likely have no (easy) hope of overcoming.

In...

ola.hallengren.com

I don't work for Red Gate (although I am a Friend) and I can recommend their Source Control product too.

1) Permissions?

2) Patch up to latest build?

3) Check Connect for a similar issue?

raysteve43 (5/13/2014)

---

I am running SQL 2012 on Windows Server 2008. I have set the maximum allowed memory for SQL Server. Also, I've installed all of the latest SQL...

Jeff, if I recall correctly earlier versions of the Fast Track Datawarehouse appliance was spec'd for mostly HEAP tables to ensure the most efficient sequential scans. Not sure of...