Disaster Recovery

User and Schema Association after Restore on DR Computer

by Jonathan October 27, 2009

I was faced with a situation I have yet to encounter as a DBA. I don’t know why I have yet to find this but I will write about it anyway. I have been working on a side by side upgrade/migration project going from SQL Server 2000 to SQL Server 2005. I have the two boxes configured but in the upgrade we are also going to have to correct some ‘error’ in security. It is because of this fact that I just can’t migrate the master database and get all of my user associations back working together.

View Comments Read More…

Using Twitter for Corporate Disaster Recovery

by Jonathan March 14, 2009

As a technology consultant I find myself posed with questions on a daily basis with openers like “My computer at home has…” and “I am trying to do this in SQL…”.  My standard response, the one everyone seems to hate, is It depends. Recently one of the people that I work with asked me, what [...]

View Comments Read More…