Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem on restore to another server !

2 posts in Windows NT Last posting was on 1999-12-11 07:21:24.0Z
Setyo Sabdono Posted on 1999-12-10 02:59:49.0Z
From: "Setyo Sabdono" <ssabdono@kompas.com>
Subject: Problem on restore to another server !
Date: Fri, 10 Dec 1999 09:59:49 +0700
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <bfdmVmrQ$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ip28-171.cbn.net.id 202.158.28.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2841
Article PK: 1090277

1.) I have tried to backup a database from one server (NT machine) and
restore that to another server (NT machine too).
But there are problem when I look at user name with login name are not
match.
For example :
On Server 1 user name on 'personel' database is 'jack' and login name is
'jack'.
On server 2 after I restore personel database from server 1, I look jack's
user name ascociated with another login name called 'marten'. So, I can't
use database on server 2 to be used before I re-associate user name with
login name.

2) Still in a topic above, there are one user I want to delete, but there
are message from server :
"You can't drop user because user 'george' ownes thresholds in database."

Thanks for help !


--
Setyo Sabdono
PT. Kompas Media Nusantara
Jalan Gajahmada 109 - 110A
Jakarta 11140
Telp. : +62-21-2601234
Fax. : +62-21-2601622
Email : ssabdono@kompas.com


Arun Kamat Posted on 1999-12-11 07:21:24.0Z
Message-ID: <3851FB74.3B38E51C@tkg.att.ne.jp>
Date: Sat, 11 Dec 1999 16:21:24 +0900
From: Arun Kamat <annarun@tkg.att.ne.jp>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: Problem on restore to another server !
References: <bfdmVmrQ$GA.204@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 38
NNTP-Posting-Host: 24.pool22.tokyo.att.ne.jp 165.76.227.39
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2837
Article PK: 1090275

Hi Setyo,

This is because both the servers have master database and the syslogins tables
are not in sync with each other. Hence both the problems are seen.

1) One way is to syncronisze master..syslogins on both the servers. This has
some implications is both the server have different databases and users,
groups etc. If you syncronise syslogins then you may have to drop & re-create
all the users in all user databases.

2)Else you can just drop all users from destination database (where you did a
load) and recreate the users with proper permissions.

You may take a look at the sql script from stored procdure sp_adduser to
understand more about master..syslogins and userdatabase..sysusers.

regards,
Arun

Setyo Sabdono wrote:

> 1.) I have tried to backup a database from one server (NT machine) and
> restore that to another server (NT machine too).
> But there are problem when I look at user name with login name are not
> match.
> For example :
> On Server 1 user name on 'personel' database is 'jack' and login name is
> 'jack'.
> On server 2 after I restore personel database from server 1, I look jack's
> user name ascociated with another login name called 'marten'. So, I can't
> use database on server 2 to be used before I re-associate user name with
> login name.
>
> 2) Still in a topic above, there are one user I want to delete, but there
> are message from server :
> "You can't drop user because user 'george' ownes thresholds in database."