• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

table names changed in resotre

I took a sql database backup from my older website and restored it on the new one. Strangely all the tables got prefixed with a name and now all my queries/views/stored procedures are not working.

How do i resolve this?
0
RTKHOT
Asked:
RTKHOT
  • 2
1 Solution
 
teebonCommented:
What was the prefix?
Are the source database and the target database of the same version?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I presume what you see is that the "dbo/sa" account from the master server is not the default owner of the db.
make sure the login you use to perform the restore does have db_owner permissions in the database, that should solve the problem of the default "dbo" prefix
0
 
RTKHOTAuthor Commented:
the original prefix was dbo (it was an older sql version)

in the new database, all tables have a prefix of the username (i guess)

how do i change it back to dbo?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now