神魂顛倒論壇logo

icon
首頁Microsoft 應用技術區資料庫 MS SQL → Copy Database fails on last step using the SQL Management object method

Silverlight 5 | 雷射溶脂 | 瘦小腹 | 植髮 | 眼袋 | 玻尿酸 | 電波拉皮 | Flash | 購物車 | Flash Player 11.2 | 豐胸 |

下一主題 上一主題


Copy Database fails on last step using the SQL Management object method


Copy Database fails on last step using the SQL Management object method 簡版






 One method of creating a copy of an on premise CRM database is to use the copy database method. But it has to be a database name that does not exist in the SQL instance.
Afterward a few scripts are run to set the org ID and then there is a process in the CRM Deployment manager where I can import that new databases into a new instance, and in the process run a utility that allows for the users to be mapped to the new organization. This supplies new GUIDS for the users in the System User base table in the org database. I first got the failure in my dev environment, and since the copy database wizard seems to use the account for the SQL Server Agent, Switched it to local security account and restarted the service. Running the copy database wizard then finished and I had a copy of Production in a new database with a new name. I imported it into a new organization and updated the GUIDS for the new users and I was in business. The new site came up in the browser and I had another instance in server.This worked fine in my lab, but on the client's site, not so much in the clients production environment. The job fails with an Event ID: 208 error but not much else. I configured the errors to generated in a txt file but it never writes to it. I tried the changes to the Agent account on the client SQL server but it still fails. What's the difference. The SQL server has two instances on it in production, thus it has the agent running twice on the production server.The SQL server has two instances on it in production, thus it has the the agent running twice on the production server.The SQL server has two instances on it in production, thus it has the the agent running twice on the production server. 



For more details: explainer video




Flash | 回到頂部
下一主題 上一主題