Thursday, February 13, 2014

DB2 : How to restore backup of database (IBM DB2 9.7, command for Linux,Unix,Windos)

To restore the database backup from IBM command line we can use following command.

Command:- db2 restore database <DATABASE_NAME> from <LOCATION>

LOCATION is optional in the above command. In case we are not providing location, DB2 will try to restore back from the location at which command prompt is pointing currently. 

Example:- db2 restore  database SAMPLE from C:\DB2Backups

Screenshot for the above command with LOCATION

Screenshot for the above command without LOCATION

No comments: