dbTalk Databases Forums  

master load

comp.databases.sybase comp.databases.sybase


Discuss master load in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
suraj kumar
 
Posts: n/a

Default master load - 03-04-2004 , 11:01 PM






,
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

Reply With Quote
  #2  
Old   
Bret Halford
 
Posts: n/a

Default Re: master load - 03-05-2004 , 08:29 AM






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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.