Well, it looks like I did a good job.  It works!

I ran some tests and it seems like everything is doing well.  I was thinking I had to...

I have 13 rows all full of null values.

LOL!  Now, I am really confused.

This discussion has been more helpful than me creating some quick solution over the weekend.

1.  The warehouse supervisors / managers running a report throughout the day will not...

Good questions and I appreciate them.

I am building a data warehouse that will have aggregated data.  That I would think can be upload once a day.
Then there...

Wow, I didn't think this would be so challenging.

I did the backup and restore the database onto the secondary.
I was finally able to do a transaction log...

I did check the ports with telnet to port 5022.

I actually added a rule to allow incoming traffic for ports 1433,1434 and 5022 on both servers.

Thank you for that.  I have not looked at that type solution.  But I will take a look at that method.

The production lines are going all day.  The...

I actually saw another that made it look like linked servers would be deprecated.  However, it may have just been referring to remote servers.

Thanks for the clarification.

Tony

Thank you both.  I thought I had done a good job with my performance tuning.  When I saw those connections with high CPUtime and Diskio, it made be question my...

Hello,

It is a production floor with several pcs running the same application.  Each time an employee scan a product at their station, the database keeps updated.

So...

Yes, this is what I was referring to also.

I assumed it was adding it as a C drive.  I am not sure now.  However, if thought it suggests...

The configuration does advise but only at the 1 TB level.  It gives you up a TB but this is allocated to c drive.  If you want additional drives, you...

Again, I really appreciate your insight.  I really think the geo replication is going to work for us.

Thanks.

Thanks Grant.  I really appreciate your insight. 

No, I get it with the readable secondary, I can have my reports look to a readable secondary.  That is a big...