Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Rollback Service Pack

9 views
Skip to first unread message

Jacques

unread,
May 3, 2007, 10:25:01 AM5/3/07
to
Hi,
Is it possible to roll back from Service Pack 3 to SP2 ?

By mistake, a client with the SP3 NAV Client opened a SP2
database.......didn't read the upgrade message and clicked YES and upgraded
the DB to SP3. Now the whole thing is down because of that. Other than
restoring last night Db or bulk dumping data, is there a tool that enables to
roll back ?
--
Jacques
NAV Presales

Ian C

unread,
May 4, 2007, 9:50:02 AM5/4/07
to
Are you running a native database or SQL?

If you're running under SQL you can hack the databaseversionno field in the
$ndo$dbproperty table. Change this from 60 to 40 and you should be able to
open your database with an SP2 client again. You can do this from Enterprise
Manager or SQL Server Management if you're running sql 2005.

--
NAV Blog
http://www.revolution1210.com/blog.asp?r0=3&r1=1

Jacques

unread,
May 4, 2007, 9:57:00 AM5/4/07
to
Ian,

SQL version.

Now this will enable me to open the SP3 database with the SP2 client?

Tks for your help,

Jacques
NAV Presales

0 new messages