51 reputation
1
bio website
location
age
visits member for 2 years, 5 months
seen Sep 23 at 23:21

Sep
23
comment Disaster Recovery Options for Sql Server
Having to set up logshipping for this many databases and then managing it. But I guess its no different than what I am doing now. I do have a question about how log shipping handles Differential backups. Do I have to stop doing differentials for this to work?
Sep
23
asked Disaster Recovery Options for Sql Server
Jul
5
comment Need to add a Table Level Constraint to prevent bad data - Constraint is not working
Thanks. I think we will hold off on this for now.
Jul
5
comment Need to add a Table Level Constraint to prevent bad data - Constraint is not working
It's not really a check to see which one should win. Its a check that says fail the insert/update if there is already a record for that claim that has LastAssigned=1. Does that make sense?
Jul
5
asked Need to add a Table Level Constraint to prevent bad data - Constraint is not working
May
25
comment How to handle reporting of an extreme amount of databases in SQL Server 2005?
Interesting idea. My concern would be restoring the dbs over 20gbs every night. And how long that would take. And if the restore for some reason does fail, which would be great to know for testing purposes, would not be so good for our customers who would now not be able to get to their reports.
May
24
comment How to handle reporting of an extreme amount of databases in SQL Server 2005?
No we do not have Analysis services at this point. We are using reporting services with stored procs stored in the oltp customer databases.
May
24
awarded  Student
May
24
asked How to handle reporting of an extreme amount of databases in SQL Server 2005?