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.
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.