Owner of the database after restore
From: Abraham (binu_ca_at_yahoo.com)
Date: 07/27/04
- Next message: Hari Prasad: "Re: Owner of the database after restore"
- Previous message: Ayad: "Re: SQL 2K EE on Win 2k3 + supportable RAM"
- Next in thread: Hari Prasad: "Re: Owner of the database after restore"
- Reply: Hari Prasad: "Re: Owner of the database after restore"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 11:40:11 -0400
I restored a database SynComp_TEST from a backup using a login testbinu,
which have dbcreator fixed server role. ( SynComp_TEST not exists earlier)
I got below message ..
Processed 1672 pages for database 'SynComp_TEST', file 'Metadata_001' on
file1.
Processed 104 pages for database 'SynComp_TEST', file 'Datasets_001' on file
1.
Processed 8 pages for database 'SynComp_TEST', file 'Indexes_001' on file 1.
Processed 1 pages for database 'SynComp_TEST', file 'Logs_001' on file 1.
Msg 916, Level 14, State 1, Server BOYD, Line 1
Server user 'testbinu' is not a valid user in database 'SynComp_TEST'.
Msg 3013, Level 16, State 1, Server BOYD, Line 1
RESTORE DATABASE is terminating abnormally.
Now I think the owner of the database is 'sa ' ?Am I right ?
Is there any way I can restore this database with testbinu as the owner ?
Or at least testbinu as a valid user in the database?
- Next message: Hari Prasad: "Re: Owner of the database after restore"
- Previous message: Ayad: "Re: SQL 2K EE on Win 2k3 + supportable RAM"
- Next in thread: Hari Prasad: "Re: Owner of the database after restore"
- Reply: Hari Prasad: "Re: Owner of the database after restore"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
