MYSYSAD.COM

Load Sybase Database From Tape

· Databases · Files & disks

On occasion, you may have to restore a database from a tape. This is a fairly simple and straightforward task to perform. Here is the syntax to load a Sybase database from tape.

First, get a list of the database filename(s) on the tape

# isql -Usa -Ppassword
1> load database MYDB from mytapealias with listonly
2> go

Next, restore the database from tape and then put it online

1> use master
2> go
1> load database MYDB from mytapealias with file = 'MYDBXXXXXXX'
2> go
1> online database MYDB
2> go