Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL 2005 Upgrade complete! - Post installation tasks questions!

Hi All

I have managed to upgrade our DEV and TST ECC6 systems to SQL2005 (from SQL2000) and so far all seems ok however I have a a few questions and checks I would like some help with. I have included my post installation tasks at the bottom of this post, so you know what I have done.

I have noticed that when I run SGEN I get a short dump LOAD_VERSION_LOST which I am not sure what this means.

If there is anything else I need to do or should do please let me know.

Thanks

Phil

<b>Post Installation Tasks</b>

<u>SQL Queries</u>

exec sp_configure 'show advanced options', 1

reconfigure with override

exec sp_configure 'max degree of parallelism', 1

reconfigure with override

exec sp_configure 'xp_cmdshell', 1

reconfigure with override

alter database <SID> set page_verify checksum

go

alter database <SID> set auto_create_statistics on

go

alter database <SID> set auto_update_statistics on

go

alter database <SID> set auto_update_statistics_async on

go

dbcc updateusage ('<SID>')

go

exec sp_updatestats

go

<u>SAP Tasks</u>

Check SM21/SM50/DB02/ST04/ST22/SICK for any unusual error messages.

Former Member
Not what you were looking for? View more on this topic or Ask a question