Database restore and Refresh

[Former Member]

Hi ,

I have SAP application with SQl 2000. just due to some changes happend in quality system and i will have to go through Database refresh activity ,

Can anybody plz guide me how to do Database restore from one server to another and how to refresh it . Please provide me solution step by step . i have never gone through this kind of activity .....

Thanks

Kamal Taneja.

09311454142

[Former Member]

Hi Kamal ,

Got any solution?

Pls update.

Thanks & Regards,

Nagendra.

[Former Member]

Hi All ,

Thanks For help , sorry for the delayed reply . actuly i was at client location and was so busy for last few days....

well thats for co-operating me i have got the solution...

Thanks

Kamal Taneja

[Former Member]

Yes my question has been answerd

[Former Member]

Hi kamal,

You have two procedures to refresh.

1) Backup from source system and restore it to target system.

You can restore with the backup file and, after the restoration you need to execute the sql script (user_change).

Since you never gone through this refresh activity, i wont recommend this.

2) Systemcopy.

This is the best way to perform system refresh.

But, try to do this in your test server first.

Please do not expect each and every step from Forms.

Thanks & Regards,

Nagendra.

[markus_doehr2]

> Can anybody plz guide me how to do Database restore from one server to another and how to refresh it . Please provide me solution step by step . i have never gone through this kind of activity .....

Read the system copy guides - they are step-by-step:

or you can use the method described in

Note 151603 Copying an SQL Server database

Markus