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
URL: http://www.MicrosoftDynamicsForums.com/forums/forum_posts.asp?TID=6329
Printed Date: August 22 2019 at 10:46pm


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
 


-------------
nicholas795



Replies:
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

http://support.microsoft.com/kb/871973" rel="nofollow - http://support.microsoft.com/kb/871973



-------------



Print Page | Close Window