MSSQL 2005 System refresh

[former_member312458]

Hello All ,

I am trying to do system refresh from PRD to QAS , Windows 2003 / MSSQL 2005 database, need to know step by step procedure, DB restroe , recovery and rename SID , how to do all these. main I need to know DB activities.

Thanks

Atul

[former_member524429 · Accepted solution]

Hi,

Refer [SAP Note 151603 - Copying an SQL Server database|https://service.sap.com/sap/support/notes/151603] to get step by step information about your requirement.

Regards,

Bhavik G. Shroff

[Former Member]

Hi,

Refer to the thread here - there is a step by step guide

Tony