Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    23

    Unanswered: Missing alias in database

    Hi,

    I have 2 database server. 1 is a production and another is a backup.
    There are alias in 1 of the database in the production. Normally what we did is do a backup and restore on the database on the backup server.
    But i realise the backup server's database doesnt contain the alias. How do i transfer alias over.
    Thanks.

  2. #2
    Join Date
    Mar 2008
    Location
    Paris
    Posts
    5
    Hi,

    Aliases are in YOURDB..sysalternates so they are part of the dump but they are linked to logins in master..syslogins. If the logins do not exists on the backup server or have different suid you will not see the alias.

    Philippe

Posting Permissions

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