January 7, 2005 at 7:39 am
RESTORE DATABASE BINT_Prod
FROM DISK = '\\Ribackupsrv\BIBACKUP\backup\BI\BINT_Prod_20050102 .bak'
WITH MOVE 'BINT_Prod_Data' TO 'd:\Program Files\Microsoft SQL Server\MSSQL\data\BINT_Prod_Data.mdf',
MOVE 'BINT_Prod_Log' TO 'd:\Program Files\Microsoft SQL Server\MSSQL\data\BINT_Prod_log.ldf',
REPLACE
Processed 4182448 pages for database 'BINT_Prod', file 'BINT_Prod_Data' on file 1.
Processed 19 pages for database 'BINT_Prod', file 'BINT_Prod_Log' on file 1.
Server: Msg 916, Level 14, State 1, Line 1
Server user 'BIUser' is not a valid user in database 'BINT_Prod'.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I used Query Analyzer and had connected using login 'BIUser'.
The login has Database Creators role and default database 'BINT_Prod'.
Please help!!!
January 7, 2005 at 12:23 pm
Hi,
Was it a standard login or a Local Windows user and you are restoring to another server? In this case SID (security ID) of the user will be different.
Please, ask your DBA with sysadmin rights to restore the database for you and then to run sp_changedbowner if you want a specific login to be a database owner.
Yelena
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply