cancel
Showing results for 
Search instead for 
Did you mean: 

Database refresh in Sql server 2005

Former Member
0 Kudos

Hi all,

We have ECC 6.0 on SQL sever 2005 on three system landscape.

Please suggest me how to perform database refresh from Production to QAS in SQL server 2005.

I have good knowledge on oracle database refresh like copying the backup datafiles and re-creating Controlfile and doing the post-refresh steps.

Thanks,

Subhash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

use following notes to perform system copy ( i.e system refresh )

151603 :Copying an SQL Server database (homogeneous system copy)

551915 - R/3 won't start after database restore or database copy

regards,

kaushal

Former Member
0 Kudos

Hi ,

Thanks for the reply, can you please provide any link for SQL server adminstration guide for SAP.

Thanks,

Subhash

Former Member
Former Member
0 Kudos

Hi,

Thanks for the reponse, can you please clarify the below querys.

1) In oracle we have Listener act as communication bridge b/w SAP & Oracle , is there anything same in SQLserver.

2) Patching process for Sqlserver.

3) Please provide any link to get info about Standard stored procedures which will be used in admin tasks.

4) How to configure Backup devices .

Thanks,

Subhash

Answers (2)

Answers (2)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Thanks