 |
|
Windows Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Error when restoring to another server |
Post Reply 
|
Page <12 |
| Author | |
Pilsener 
Groupie 
Joined: 20 May 2006 Status: Offline Points: 103 |
 Post Options
 Thanks(0)
 Quote Reply
 Posted: 02 August 2011 at 5:13pm |
|
Old name: username@live.no
New name: pilsener I cannot use dbo at all. I have to use the login name for the hosting account, which is pilsener. I have managed to use the database backup-wizard at the hosting provider to change ownership for all tables except these: tblLadderGroup tblSetUpOptions tblSpam tblThreadThanks tblTopicRatingVote What will happen if I delete these tables ? Will they be rebuilt by the upgrade wizard ? Edited by Pilsener - 02 August 2011 at 5:41pm |
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
Posted: 02 August 2011 at 6:07pm |
|
You should not delete any tables, they would not be rebuilt.
|
|
|
|
|
Pilsener
Groupie
Joined: 20 May 2006 Status: Offline Points: 103 |
Post Options
Thanks(0)
Quote Reply
Posted: 02 August 2011 at 7:42pm |
|
It didn't work, deletion or not.
I'm starting to run out of hair to pull out. Is it possible to create a new and empty forum/database and then copy the info from a backup of the current one ? Edited by Pilsener - 02 August 2011 at 7:53pm |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8028 |
Post Options
Thanks(0)
Quote Reply
Posted: 03 August 2011 at 9:10am |
|
It's not possible to copy data.
You should be able to use DBO with any SQL Server as it means that any user given DBO (Databasse Owner) rights to the database has full control of that object. This makes it simpler to move SQL server Database between databases without the problems that you are having. I would check with your provider about not being able to set the owner of tables to DBO as it would seem strange if you can not. This way it will also make moving to a new host in future mush simpler. Don't forget as well you can also host your forum or whole website with ourselves on our own servers. We charge a £19.95 migration fee to move the forum to our network but we can update the object owners of the database to DBO during this migration process. Website Hosting Packages Reseller Hosting Packages Web Wiz Forums Hosting package |
|
|
|
Topic Options|
Post Reply
|
Page <12 |
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
