Skip to Content
avatar image
Former Member

Sybase Restore with Multiple Devices for DATA

We have Sybase DB of size 150GB approx with 6 Devices/Device_fragment created for data SAPDATA1.......SAPDATA6 of 25 GB e

When we are trying to restore the DB from the backup the system is creating the whole Database of 150 GB into with 6 Datafiles but only with the first device i.e SAPDATA1 and it is ignoring the rest of the devices .

Kindly help me how to do the restore so that the system considers all the devices .

DB Devices Before Restore

DB Devices after Restore

Add comment
10|10000 characters needed characters exceeded

  • Hello Sourav,

    The question is not clear. How can a 150GB database fit onto a single device of 25GB??

    Please always provide the relevant outputs to demonstrate the issue. Here we need a sp_helpdb <SID> output and the load database command output. Did you drop and recreate the database before loading the dump?

    Regards

    Mehrab

  • Get RSS Feed

0 Answers