SAP didn't come up after restore

[Former Member]

Hi Gurus,

We are running SAP NetWeaver (7.0) 2004s SR2 with SQL Server 2005. Our database server crashed last night due to media corruption. I reinstalled the SQL Server 2005 and restored the database. Restore operation completed successfully. But SAP didn't come up.

What else I need to consider to bring the SAP up?

Thanks

Peter.

[Former Member · Accepted solution]

Hi Peter,

Please check the following prerequisite.

1.Use the collation type "Dictionary order, case-sensitive, for use with the 850 (Multilingual) Character Set" when you install the SQL Server 2005 instead of the correct setting of SQL_Latin1_General_CP1_CI_AS. This is most common mistake.

2.Check whether Environmental variable set properly.

3. Check whether restoration completed successfully.

Rgds,

SK

[Former Member]

Hello Peter,

what errors are u facing while bringin SAP up

Please provide the detailed info. so that we can work on it

Rohit