on 10-02-2008 1:22 PM
Good Day Guys,
Could you please throw some light on the issue below,
Our QAS is down for more than a month and we are having problems with the server on hardware side,so our company has decided to scrap up the old server and bring a new server in its place.
Could you please share your ideas as of how to proceed from having new server.My concerns.
Installing sap and Mssql from scratch naming same as our old server.Here im stuck.......whether to install a new database and do DB refresh from the production database.
Please post me all the activities to considered for a new installation and to have a copy of production installed on it.
thanks in advance,
Hi,
This is how you should proceed.
1. Take a full backup of your production - make sure it is successful.
As you cannot use the sql server detach/attach from production - you will have to do a backup and restore.
2. Uninstall your quality - the uninstall steps are there in the installation guide.
3. Install your QAS using SAPINST as per the homogeneous system copy installation guide. And select the option db using "backup/restore" when SAPINST asks for it.
4. Restore the database using the production backup and logs via the SQL Server Enterprise Manager.
5. You will have to change your schema names by following the sap note 551915 - this is only needed if your SAP system uses the MCOD convention of the form SAP<SID>.
Also, check these SAP Notes 151603, 193816for a SQL Server Copy.
Hope this helps.
Reg, Dibya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.