I am presently trying a migration of my database from discountasp.internet to arvixe.com, mainly to see if I'm able to obtain the same quality level for any better cost. I designed a backup of my database at discountasp through what they can control panel, submitted it via ftp towards the new host and used their restore tool. Then i open SQL Server Management Studio, open my database node and also the Tables node. Then i obtain the following error and that i can't see anything within the Tables node same happens for other nodes too, like Security/Customers)
Unsuccessful to retrieve data with this request (Microsoft.SqlServer.Management.Sdk.Sfc) The best happened while performing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The Choose permission was refused around the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
I had been always in a position to backup/restore DBs from/to discountasp and my local dev machine.
Could it be a mistake very specific towards the examined host Arvixe or perhaps is it a mistake that somebody has the capacity to explain? You don't need to state that prior to the restore, at Arvixe, I could produce a database, tables, look inside and have fun with it. This is actually the restore operation that screws up everything.
PS: obviously I've a wide open ticket with Arvixe too but to date they aren't able to help...
Update: this problem didn't have explanation. Under Arvixe Clubpenguin, I produced another user, gave it use of the database also it labored. I (and Arvixe) have no clue why the very first user had a general change in its permissions to avoid me being able to access the restored DB.
There's no user planned towards the restored database using the right you have to perform a simple choose. (custom) customers aren't moved having a backup/restore.
I' have no idea ik you will get towards the security node, but there you need to add the mapping for your user account.
This t-sql script adds YourUserName user as db_owner to YourDatabaseName
USE [YourDatabaseName] GO Professional sp_addrolemember N'db_owner', N'YourUserName' GO