August 13, 2012 at 5:42 am
Hi,
Please can someone help here. I'm trying some things on some hyper v machines, and have come accross a major probblem with something as simple as copying a database.
I have tow instances on one Virtual Server, and am trying to copy from one to the other. I have checked all the permsissions, and they are all allowed. I have checked all the Dcom Component services and they are all correct. Firewall rules are set, and the group policy on the domain controller is correct, and server agent is enabled on each instance.
Yet everytime I try to copy it, it fails due to maximum amount of errors allowed. I don't want to change the rule to allow errors, as I want the database to copy correctly, but nothing I'm trying seems to work.
Can anyone help please?
Thanks
Dan
August 13, 2012 at 5:51 am
If you're trying to copy a DB to another instance, why not backup/restore?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2012 at 5:53 am
Yeah, I'm thinking I will have to do that, just think there has to be something wrong with setup if I can't do it with the copy database wizard?
August 13, 2012 at 6:09 am
Personally I never use the copy database wizard. It's an expensive, slow way of doing what backup/restore (or detach-copy-attach) does. Probably the only time I'd use the wizard is for copying a DB to a lower version.
Without seeing the errors, I can't begin to suggest a cause or reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2012 at 6:50 am
Yeah, you're right. Did a backup/restore which worked a treat, think I'll be using that method from now on.
Thanks for your help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply