Results 1 to 5 of 5

Thread: Load master DB

  1. #1
    Join Date
    Sep 2008
    Posts
    40

    Unanswered: Load master DB

    Hi all,
    I have doubt,might look silly..
    Is it possible to load master db dump from server A to server B.
    1. The serverB doesnot have exact disk structure as server A (menas server A device location is different from B)
    2. Is it possible to load user database to the server B from server A which has db size created as server A but the no of devices and physical location of devices are different.
    3. Steps to load master DB..

    Pls some one help..

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    1. Yes but the resulting devices will be the same as the original master
    Might have to then do dbcc dbrepair (<dbname>,dropdb) and sp_dropdevice
    2. Yes, normal load database
    4. See the online documentation on sybase's website

  3. #3
    Join Date
    Sep 2008
    Posts
    40
    Hi pdreyer,
    I am not clear with the point 1, if u dont mind can u pls explain

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    All the devices from master..sysdevices in the loaded master will point to files that do not exist in the server. When you start the DB server all files will be unavailable as you say "serverB does not have exact disk structure as server A".
    So loading master is only useful to restore your logins.

    You might be able to create links if the device sizes are the same e.g.
    ln -s /part_on_serverB/datafile1 /path_on_serverA/datafile

    else you would probably have to mark the databases suspect, drop them, drop the devices and recreate from scratch.

  5. #5
    Join Date
    Sep 2008
    Posts
    40
    Thanks a lot man....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •