Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 58

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 29th September 2004, 12:17
Jabran Jabran is offline
Join Date: Oct 2003
Posts: 31
Jabran is on a distinguished road
Baan: 7.1c.05.148 - DB: SQL Server - OS: Windows NT 4. Server
Red face SQL Server 7.0 SP4 + BaanERP compatiblity

Hello All,

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.

Reply With Quote
Sponsored Links
Old 4th October 2004, 11:49
Jabran Jabran is offline
Join Date: Oct 2003
Posts: 31
Jabran is on a distinguished road
Baan: 7.1c.05.148 - DB: SQL Server - OS: Windows NT 4. Server
Any one there ?

Please share your experiences and thoughts for the above problem.

Thank your for your time and help.

Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11
BAANERP 5.0c and SQL Server 2000 installation isimeon Tools Administration & Installation 2 5th June 2003 08:18
BaaN C4, Windows 2000 Advanced Server and SQL 7.0 Server rdheeraj Operating Systems & Databases 1 30th May 2003 19:32
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 13:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 13:22

All times are GMT +2. The time now is 18:43.

©2001-2018 - -