Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    42

    Unanswered: stanby server/log transfer

    when i do the experiment,i have some questions
    1.when i click 'finish',it shows me :
    14261rimaty_server_name.primary_database_name ('(') already exists
    2.when i use: use msdb
    exec sp_change_secondary_role 'northwindlogshiop
    it shows me :server:message:22029,level 16
    sqlmaint.exe failed
    3.
    when i use
    use msdb
    exec sp_change_monitor_role 'primary_server','secondary_server','northwindlogs hip','c:\productionlogs'
    it shows me :
    server:message 14442,level 16,procedure sp_change_monitor_role
    row 18,change role failed


    can u help me .thanks in advance

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Is the database in cold standy by mode?

  3. #3
    Join Date
    Nov 2003
    Posts
    42
    yes.it is cold.
    can anybody help me ??/

Posting Permissions

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