Upgrade from 1.2 to 1.3 Problems

Nov 25, 2006 5 Replies
C

IHAC,



Who we have upgrade from RMS 1.2 / MSDE to RMS 1.3 and SQL 2005 Express. After the upgrade we can connect to the database and everything works except for two things:


  1. We cannot upgrade the database schema under the RMS Administrator. The upgrade version is blank and it says the current version is 1.2 update

6/25/2003.


  1. The database is 96% full and we upgrade to SQL 2005 Express to take advantage of the 4 GB limit.



So we are stuck and running out of room on the busiest sales weekend of the year. Any help would be greatly appreciated.



Chris Chandler DH Innovations, LLC


Vote
Twitter Facebook LinkedIn
R
  1. there is no database update schema for 1.3

  1. of the databases 100%, 96% is used and 4% is free. It does not mean that it is 96% of the 4gig limit for sql 2005

No problem.

Vote
Twitter Facebook LinkedIn
C

Will the RMS 1.3 database grow automatically or should I be worried?

Chris

"root" wrote:

Vote
Twitter Facebook LinkedIn
R

it will automatically grow as needed, not to worry. this is normal.

"Chris Chandler (DHI)" wrote in message news: snipped-for-privacy@microsoft.com...

Vote
Twitter Facebook LinkedIn
C

Sorry we are just being careful b/c of the time of the year. The database stats are:

Size: 2191.00 MB Space Available: 113.72 MB Usage: 95%

So the SQL database will automatically add space. I figured I would see Space Available of 4.0 GB after the upgrade to SQL 2005 Express.

Chris

"root" wrote:

Vote
Twitter Facebook LinkedIn
G

Hi Chris,

You can set your databse settings also:

1) Backup your data 2) Run this script from QUERY ANALYZeR

ALTER DATABASE databasename SET AUTO_SHRINK ON, AUTO_UPDATE_STATISTICS ON, AUTO_CREATE_STATISTICS ON, RECOVERY SIMPLE, TORN_PAGE_DETECTION ON

It will somehow reduce the chances of data grows rapidly.

I hope it helps.

Good Luck

"Chris Chandler (DHI)" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required