Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Error when restoring to another server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error when restoring to another server

 Post Reply Post Reply Page  <12
Author
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 123
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 02 August 2011 at 6:07pm
You should not delete any tables, they would not be rebuilt.
Back to Top
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 123
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.