|
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 |
![]() ![]() ![]() ![]() ![]() 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 |
|
![]() |
|
Sponsored Links | |
![]() |
|
nicholas795 ![]() MicrosoftDynamicsForums.com Member ![]() Joined: July 30 2012 Location: ma Status: Offline Points: 2 |
![]() ![]() ![]() ![]() ![]() |
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 |