sql backup restore to new system

[Former Member]

Hi, I tried this question in the netweaver admin area with no much help so far.

I have a backup from my production (.BAK) which I need to restore to build another system. Could anyone tell me the steps to do this?

My doubt is whether I have to build another system before I restore the Prod Database to it. If not, what are my options?

Thanks,

Jim

[Reagan]

Hello

If you have a backup of the production database then I suggest you to install a new system on the target machine.

Then restore the database to the target machine.

Note 683447 - SAP Tools for MS SQL Server

Note 151603 - Copying an SQL Server database

Regards

RB

[former_member187565]

Hi Jim,

I assume that is SAP application.

It seems you are going to perform homogeneous/heterogeneous system copy activity.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/48/bb2361cf555295e10000000a42189b/frameset.htm

In the above link you find the restore process and all details.

Regards,

Rafikul Hussain

[Sriram2009]

Hi Jim

Kindly refer the link

http://technet.microsoft.com/en-us/library/ms177429.aspx

http://social.technet.microsoft.com/wiki/contents/articles/7654.how-to-restore-a-database-backup-usi...

Thanks

Ram