SQL Server 7.0 SP4 + BaanERP compatiblity
We have BaanERP 5c (SP12) installation on "Windows NT 4.0 Backoffice Server SP6a", with "SQL Server 7.0 (No service Pack installed)". We are to make a complete Baan Database restore trial on "Windows 2000 Advanced Server (SP4, with Terminal Services enabled)".
SQL Server 7.0 installation on "W2k Server with terminal services" requires, "SQL Server 7.0 SP4".
The Live SQL Server has no SQL Server service pack installed. With this configuration, we were able to restore BaanDB user database completely to "SQL Server 7.0 SP4" on "W2k SP4". But structures of SQL Server system databases (master, msdb, etc.) are not same in differnt SQL Server Sercive Packs. Thus these database could not be restored and hence DB user information and access rights information was missing on W2k. (We are using Veritas Backup Exec 8.5 SQL Server Agent to backup and restore the database.)
The above problem may be solved, if we install SQL Server 7.0 "SP4" on Live Server, take a backup, and then restore it to W2k. In this scenario, the "backup source" and "restore target" will have same SP levels of SQL Server, and system dataases will be restoreable as required.
The question Is:
If SP4 of SQL server 7.0 is installed on the Live server, Should there be any concern that it may have any side effects with BaanERP? If yes, then what it may be and are there any workyrounds to avoid those?
One other piece of information is: SQL Server 7.0 doesnot support MSDAC 2.6+ without SP4. Keeping this in mind, can the upgrade to SP4 of SQL Server raise any compatibility issues?
Please provide as many concerns as possible for this scenerio :-).
Thanks in advance.