Hi,

I need to clone our existing enviroment to make some test upgrading O.S(4.0 to 2000) and SQL Server (6.5 to 2000).

Here the steps I'm thinking to do in test server

1.- Install O.S 2000
2.- Install SQL Server 6.5
3.- Import database from production server
4-. Copy baan application $BSE directory

Could somebody tell me if this is the best way to do it??

I don´t have experience in SQL Server, could somebody give and advice on how to export and import a database??

Thanks in advance

JP

Have a look at this thread (http://www.baanboard.com/baanboard/showthread.php?s=&postid=38412#post38412). It should give you some good ideas.

We have just been trying to do a very similar thing. We are have produced a copy of our live environment on a test machine, where the test machine has totally different hardware so we can't do a stanard windows DR. We are using Windows 2000 Server SP3, SQL Server 2000 SP3 and Baan IVc4 SP12.

I am attaching our restore procedure, it should be pretty generic.

Probably the strangest big is that we are doing a backup of sql server to a dump on the server (rather than direct to tape), we are then restoring that dump file to the test server and using that to perform a sql restore locally.

I hope you find this information useful.

Phil