Backup and Restore SQL

[Former Member]

Dear Gurus,

I have offline database backup for DATA1, DATA2 , DATA3 and LOG1 file.

Now I have one more Demo server. That server also have some Database SID.

How to detach and Attach database as well as do the work on the attach database client.

Please tell me advice.

[ganesh_borase2]

Hi,

If you SID is same , then simply

1. Detach data from demo system.

2. copy the database (backup) to the demo system.

3. Attach database

4. Run STM tool and select appropriate option.

Thanks

Ganesh

[Former Member]

Hi,

You need to attach the database with the old SID, then, backup the database and restore from the .bak to the newer SID, execute the cahnge schema script and Schema4SAP.

Regards

[Former Member]

Hello,

First get fimiliarity with ms Management Console. And using Installation master you can do backup/restore and attach/detach method, to make the other system.

Refer the following useful notes also.

SAP Note 1420452 - FAQ: Restore and recovery with MS SQL Server

SAP Note 683447 - SAP Tools for MS SQL Server, after SQL DB restore.

Note 555223 - FAQ: Microsoft SQL Server

Regards,

MSR

[sunny_pahuja2]

Hi,

Check SAP Note 151603 - Copying an SQL Server database.

Thanks

Sunny