35 reputation
7
bio website None
location Columbus, OH
age 29
visits member for 2 years, 5 months
seen Apr 6 at 3:16

SQL Business Analyst, InfoSec Guy, and Network Monkey with a smattering of C#, Javascript, and XML in the background.


Feb
20
awarded  Popular Question
Apr
16
awarded  Commentator
Apr
16
comment Availability Strategies in MS SQL Server 2008
Yeah, and I'm not sure that's in my budget, so we'll probably stick with T-Log Shipping.
Apr
12
comment RSync Database File Deltas in SQL Server 2008
Very excellent points, thank you.
Apr
12
comment RSync Database File Deltas in SQL Server 2008
Yeah, rsync seemed like a good idea for a split second, until I remembered that SQL server is very picky about how its files operate...
Apr
12
comment RSync Database File Deltas in SQL Server 2008
Thank you very much - this will help immensely in explaining the situation to my bosses.
Apr
12
accepted RSync Database File Deltas in SQL Server 2008
Apr
12
awarded  Supporter
Apr
12
asked RSync Database File Deltas in SQL Server 2008
Apr
12
awarded  Scholar
Apr
12
accepted Availability Strategies in MS SQL Server 2008
Apr
9
comment Availability Strategies in MS SQL Server 2008
That's an ugly one Eric, I'm not entirely sure. Right now they want to do a firewall pin-punch to allow remote upload of the T-Logs which is an argument for a second instance (I think our licensing can handle it? I'm not sure though.) Log Shipping - as I recall - doesn't require them to have credentials in to SQL Server, just for us to set up the job to pull in the T-Logs so we have control over which logs we process and where they go, etc.
Apr
9
awarded  Student
Apr
9
comment Availability Strategies in MS SQL Server 2008
I would like to do a lab experiment to determine what our sync-gap would be with Async Mirroring as we generally don't do big commits; just a lot of little ones (1 work item generates about 12 single-row insert statements and each database can have between 1-150 work items per 15 minute window depending on customer size)
Apr
9
comment Availability Strategies in MS SQL Server 2008
Basically I'm looking to build a second site with which I can run our SaaS product from in the event the primary site suffers earthquake, cthulhu-esque horror, etc etc. So I need that site available as a warm standby. I'm pushing Mirroring for our hosted guys, but I'm not sure how to handle DR services for off-site. Since I don't have control of their config, I doubt they'll let me set up a mirror over here.
Apr
9
awarded  Editor
Apr
9
revised Availability Strategies in MS SQL Server 2008
added 119 characters in body; edited title
Apr
9
comment Availability Strategies in MS SQL Server 2008
We are already taking 15 minute T-Log backups, the question is more an availability one, so I apologize for the misleading title. We are contemplating offering DR services to OnPrem customers as part of this exploration - I'm basically doing an R&D effort right now.
Apr
9
comment Availability Strategies in MS SQL Server 2008
@Eric Higgins Ideally it's one instance with everyone in it, but I'm not sure if I can have mirroring on some DBs and Log Shipping on others within the same instance.
Apr
9
comment Availability Strategies in MS SQL Server 2008
@shark I need a business continuity strategy, so would availability I guess availability would be a more apt title? Basic goal is to provide a Disaster Recovery solution with an RPO of 15 minutes and an RTO of an hour or less; and things other than DB recovery need to happen.