suraj_c (AT) hotmail (DOT) com (suraj kumar) wrote in message news:<64719074.0403042101.35befa76 (AT) posting (DOT) google.com>...
Quote:
,
Hi friends,
How can i confirm that the backup of master which iam taking is clean
and won't create problems . loading on the same database is quiet
risky as it may cause problem to earlier running system. We are using
12.5.1
is there any other way to acheive this
Suraj |
You can install a new server on the same host, shutdown the main ASE,
load the dump of master into the new server. If it comes up with all
your databases, passes dbcc checks, etc., then the dump is good. If
not, just shutdown and reboot your original, as the original master
device is still there, untouched.
Alternatively, you can juse create a new master device and point the
existing runserver file at that, shutdown, boot using the new master
device (you will now have something that looks like a new server, but
no stored procedures) and try loading the dump...
-bret