how to restore the backup which we taken from db13 ?

[Former Member]

Hi .........

I am taking full back up from DB13 to hard disk and tape drive every day.

Please tell me how to restore this backup which is taken from db13.

4.7E, MSSQL , Windows 2003 server.

Gayatry.

[Former Member · Accepted solution]

If its the same server you took the backup from the backup history for the DB will be stored against it. If its a different server you will need to catalog the backup tape to read in the history/contents.

Lets assume its the same server, with the same file locations.

From SQL Ent Mgr - with SAP stopped.

right click the DB

select restoredb

select the set you want to restore from the history

select the options you need (ie leave off line for addition TL restore, or bring online)

It really is that simple - you cant go wrong (assuming you select the correct set!)

[former_member204746]

you must use Enterprise manager. check on Microsoft's website