Print Page | Close Window

Need to copy database GPv9 SQL5

Printed From: Microsoft Dynamics Forums
Category: Microsoft Dynamics GP (Great Plains)
Forum Name: GP - Installation and Administration
Forum Discription: Installation, Upgrade, Service Pack, Security, Database, Administration, SQL Server, Login Issues, System Errors, Performance, EDI, Business Portal, and related topics
Printed Date: January 21 2020 at 2:34pm

Topic: Need to copy database GPv9 SQL5
Posted By: nicholas795
Subject: Need to copy database GPv9 SQL5
Date Posted: July 31 2012 at 8:52am

Is there a easy way to copy a database file .mdf.  We have SQL5 and Preat Plains ver 9  running on a XP 2000 server. the application has 2 choices at logon the main database  and a test database both work fine. The test database is outdated by a few years  and needs to be a mirror image of the main database. I tried to just copy the main .mdf file then rename it as the test database,  when I tried to open the new file I got the following error  

"a get/change first operation on table co process failed accessing SQL data"
Any help is appretiated


Posted By: Rohtash Kapoor
Date Posted: August 04 2012 at 1:56pm
Please refer the to following article:


Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, or SQL Server 2008" rel="nofollow -


Print Page | Close Window