Re: Owner of the database after restore
From: erik (erik_at_test.com)
Date: 07/27/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Copy database and table data"
- Previous message: Steve: "Re: Date Format"
- In reply to: Abraham: "Owner of the database after restore"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 09:01:19 -0700
If the restore was successful you can see the database owner through
enterprise manager or by using the sp_helpdb system stored procedure.
You can change the owner for the database using the sp_changedbowner system
stored procedure. However, note from BOL that testbinu login must already
exist.
erik
solien technology, inc.
"Abraham" <binu_ca@yahoo.com> wrote in message
news:%2334ScB$cEHA.3664@TK2MSFTNGP12.phx.gbl...
> 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: anonymous_at_discussions.microsoft.com: "Re: Copy database and table data"
- Previous message: Steve: "Re: Date Format"
- In reply to: Abraham: "Owner of the database after restore"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
