How To Move a Time Matters and PCLaw Database to a New Server

sqlThis is an updated post to my previous entry regarding moving LNTPA Practice Advantage 9 to a new server.  This time I had to move Time Matters 11 from SBS 2003 server running SQL 2005 SP2 (Server A) to Server 2012 R2 running SQL 2008 R2 Express (Server B).  Time Matters specifically has to be installed as a blank database first to let the built in SQL security accounts be created, then you run a SQL query to reset the permissions after attaching the copied MDF / LDF files.  Here is how to do it. Continue reading “How To Move a Time Matters and PCLaw Database to a New Server”

0