Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - Installation and Administration
  New Posts New Posts RSS Feed - Need to copy database GPv9 SQL5
  FAQ FAQ  Forum Search   Register Register  Login Login


Need to copy database GPv9 SQL5

 Post Reply Post Reply
Author
Message
nicholas795 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: July 30 2012
Location: ma
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote nicholas795 Quote  Post ReplyReply Direct Link To This Post Topic: Need to copy database GPv9 SQL5
    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
Back to Top
Sponsored Links


Back to Top
Rohtash Kapoor View Drop Down
MicrosoftDynamicsForums.com Moderator
MicrosoftDynamicsForums.com Moderator


Joined: July 06 2005
Location: United States
Status: Offline
Points: 655
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rohtash Kapoor Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com