|
|
Need to copy database GPv9 SQL5 |
Post Reply 
|
| Author | |
Rohtash Kapoor 
MicrosoftDynamicsForums.com Moderator 
Joined: July 06 2005 Location: United States Status: Offline Points: 655 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Need to copy database GPv9 SQL5Posted: 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 |
|
 |
|
| Sponsored Links | |
|
|
|
nicholas795
MicrosoftDynamicsForums.com Member 
Joined: July 30 2012 Location: ma Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options