Re: Permission to restore databases and access them without being

Hi Erland,
Thank you for your clarification. I misunderstood before, but anyway I had some
interesting findings here based on my test and I would like to post it here.

Yes, if the login was not existed in the old database, the RESTORE statement was
executed with the error message:
Server user '%s' is not a valid user in the database '%s'.
(Known issue in the KB article, http://support.microsoft.com/kb/240872/en-us.)

The RESTORE seemed failed, right? However it was not true. The database was actually
restored even with this error message. The problem was that the current user could not
be created in the newly restored database. However you can manually assign the
permissions with a sysadmin account. There were no data loss based on my observation.

You may further check this. I think that we can make a conclusion that even the user is
not existed in the original database at that time, the database can be restored, however
you need to manually resolve the permission issues after you restore the database.

Thank you again for your great contributions to Microsoft Managed Newsgroup and Have
a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================







.

Relevant Pages

  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Re: Unbound dgv - save two of the columns to a join table
    ... SqlCommand/OleDbCommand to save the values back to the database. ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: How do I set the login for user dbo in a database
    ... Microsoft MSDN Online Support Lead ... You can send feedback directly to my manager ... How do I set the login for user dbo in a database ... I have to do the restore as Overwrite the existing database because ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... > where the backup of the database. ... Before you can start to restore the SharePoint Services databases, ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)