Skip to Content
0

Sybase Restore with Multiple Devices for DATA

Apr 17 at 06:48 AM

18

avatar image
Former Member

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

10 |10000 characters needed characters left 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

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers