cannot restore from backup

[Toskey Stone]

I cannot restore a backup ssb file to a different computer.

Message: Cannot restore this database because you were not authorized to
back up or restore databases when this one was originally backed up...
Contact database owner or system administration..."

Great. I *am* a single user, so I've contacted myself and I don't know the
answer.

Using BCM/Outlook 2007. Vista machine. Backed up to USB drive. Restored to
an XP notebook. Worked on for several days. Backed up.

I tried restoring it to the admin account on by Vista box, and it worked.

But I of course can't see that from my user account. My user account was
changed to be an administrator, so I should have the same rights, yes?

Did a google on the error message and found no help.

Hope someone here has the magic bullet.

toskey

 

[Luther]

I cannot restore a backup ssb file to a different computer.

Message: Cannot restore this database because you were not authorized to
back up or restore databases when this one was originally backed up...
Contact database owner or system administration..."

Great. I *am* a single user, so I've contacted myself and I don't know the
answer.

Using BCM/Outlook 2007. Vista machine. Backed up to USB drive. Restored to
an XP notebook. Worked on for several days. Backed up.

I tried restoring it to the admin account on by Vista box, and it worked.

But I of course can't see that from my user account. My user account was
changed to be an administrator, so I should have the same rights, yes?

Did a google on the error message and found no help.

Hope someone here has the magic bullet.

toskey

Vista doesn't automatically grant admin privileges to a user in the
admin group unlike earlier versions of Windows.

Given that you've already restored the db as user admin, to grant
ownership back to your regular login by running the sp_changedbowner
sql stored procedure.

 

[Toskey Stone]

Sorry to be a light-weight on this, but I don't know how to go about running
the sp_changedbowner
sql stored procedure. I'll try searching for info, but if you can offer any
specifics, please do.

 

[mrtimpeterson via OfficeKB.com]

Toskey,

Don't you just love this Microsoft induced madness! They somehow expect
those who don't do computer tech for a living to just KNOW how to deal with
the needless run around of this complexity. Even if you attempt to
concsientously learn and adapt to this it can take TOO MUCH TIME AND HASSLE!!

-THP

Sorry to be a light-weight on this, but I don't know how to go about running
the sp_changedbowner
sql stored procedure. I'll try searching for info, but if you can offer any
specifics, please do.
[quoted text clipped - 27 lines]

ownership back to your regular login by running the sp_changedbowner
sql stored procedure.