I'm trying to back up my database to another computer. I am the sole user /
owner of this database. I backuped the file just fine, transferred it to the
other computer, went through the restore process and got the following error
message:

You cannot restore this database becuase you were not a user when the
database was backed up. Contact the owner of the database or a system
administrator for more information. Your original database has not changed.

Can anyone help me out?

> You cannot restore this database becuase you were not a user when the
> database was backed up. Contact the owner of the database or a system
> administrator for more information. Your original database has not changed.

BCM seems to add some pretty strange access to what should be a
straightforward SQL Server database. From other posts I have read on here
you might have some luck if you try logging onto the new computer with
exactly the same user name and password as were on the previous machine.

Another way of moving may be to use the SQL Server Management Studio to
detach the database from the original machine when nobody is accessing the
data, then copy the .MDF and .LDF files to the new machine, then re-attach
the original database on the original machine. Now go to the new machine and
again in SSMS attach the copied files to the database instance there.

Kevin

Hello,

This is Mani from India, r u working on WinVista or WinXP...?
PLz let me know. I wil mail you the next steps to follow.

If you are working on WinVista then :
Click on Start - > Go to Control Panel - > go to User Account --> Select you
user login name - > Click on Turn User Account Control on or Off - > then
UNcheck the box UAC - Use User Accoutn Control.

Then try to import the BCM contacts.

If still any more issues plz mail to me: (E-Mail Removed)

All the best.

By,
Mani.


"jgrif08" wrote:

> I'm trying to back up my database to another computer. I am the sole user /
> owner of this database. I backuped the file just fine, transferred it to the
> other computer, went through the restore process and got the following error
> message:
>
> You cannot restore this database becuase you were not a user when the
> database was backed up. Contact the owner of the database or a system
> administrator for more information. Your original database has not changed.
>
> Can anyone help me out?

Kevin,
Thank you so much for taking the time to respond. Your anwer is a bit over
my head I must admit.

anyway you can dumb it down for me?

"kevinw" wrote:

> > You cannot restore this database becuase you were not a user when the
> > database was backed up. Contact the owner of the database or a system
> > administrator for more information. Your original database has not changed.
>
> BCM seems to add some pretty strange access to what should be a
> straightforward SQL Server database. From other posts I have read on here
> you might have some luck if you try logging onto the new computer with
> exactly the same user name and password as were on the previous machine.
>
> Another way of moving may be to use the SQL Server Management Studio to
> detach the database from the original machine when nobody is accessing the
> data, then copy the .MDF and .LDF files to the new machine, then re-attach
> the original database on the original machine. Now go to the new machine and
> again in SSMS attach the copied files to the database instance there.
>
> Kevin

Hey Mani,
I'm working on XP...

"Mani" wrote:

> Hello,
>
> This is Mani from India, r u working on WinVista or WinXP...?
> PLz let me know. I wil mail you the next steps to follow.
>
> If you are working on WinVista then :
> Click on Start - > Go to Control Panel - > go to User Account --> Select you
> user login name - > Click on Turn User Account Control on or Off - > then
> UNcheck the box UAC - Use User Accoutn Control.
>
> Then try to import the BCM contacts.
>
> If still any more issues plz mail to me: (E-Mail Removed)
>
> All the best.
>
> By,
> Mani.
>
>
> "jgrif08" wrote:
>
> > I'm trying to back up my database to another computer. I am the sole user /
> > owner of this database. I backuped the file just fine, transferred it to the
> > other computer, went through the restore process and got the following error
> > message:
> >
> > You cannot restore this database becuase you were not a user when the
> > database was backed up. Contact the owner of the database or a system
> > administrator for more information. Your original database has not changed.
> >
> > Can anyone help me out?

> Thank you so much for taking the time to respond. Your anwer is a bit over
> my head I must admit.
>
> anyway you can dumb it down for me?

Sorry about that.

For the first part, are the user name and password on the old machine
different in any way to those on the new machine? If so, try creating a
Windows user on the new machine with ientical user name and password to those
on the old machine, log in with this and try what you were doing again.

I will withdraw my second suggestion as probably unsuitable for you.

Kevin