vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| , 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 |
| ||||
| suraj_c@hotmail.com (suraj kumar) wrote in message news:<64719074.0403042101.35befa76@posting.google. com>... > , > 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 |