Recover user database from device files

[unknown]

Hi DBAs,

How Do I recover a single 'user database' from device files?
Example situation:
- The "DESENV" database was droped and its device files too;
- I don't have any dump file, but I have the actual device
files of it;

I tried to use 'disk reinit' and 'disk refit', but I don't
know if this is the best practice for this case.

Best Regards...

Jorge.

[Rob Verschoor]

Disk reinit and disk refit is indeed the right way to do this.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Post by unknown
Hi DBAs,
How Do I recover a single 'user database' from device files?
- The "DESENV" database was droped and its device files too;
- I don't have any dump file, but I have the actual device
files of it;
I tried to use 'disk reinit' and 'disk refit', but I don't
know if this is the best practice for this case.
Best Regards...
Jorge.

[unknown]

Thanks, Rob!

Jorge.

Post by unknown
Hi DBAs,
How Do I recover a single 'user database' from device
- The "DESENV" database was droped and its device files
too; - I don't have any dump file, but I have the actual
device files of it;
I tried to use 'disk reinit' and 'disk refit', but I don't
know if this is the best practice for this case.
Best Regards...
Jorge.