CRM Forum Tag: crm database

CRM Forum Tag: crm database http://forum.crmreports.com/ User-to-user CRM related forums en Sun, 01 Aug 2010 01:36:28 +0000 UG Bot on "How do you uninstall the CRM 3.0 MSDE instance?" http://forum.crmreports.com/topic/how-do-you-uninstall-the-crm-30-msde-instance#post-1959 Thu, 11 Sep 2008 17:08:31 +0000 UG Bot 1959@http://forum.crmreports.com/ Newsgroup subject: Re: Uninstalling the CRM 3.0 Laptop Client Archived from: microsoft.public.crm Author: Dan Hi Yeshua, We don't have any clients set up like that so I cant test it for you, but if memory serves me correctly you can drop down to a command line (osql.exe if think, is the msde command utility) and drop the databases using tsql (check out the MSDE online help DROP DATABASE would be a good start). If the files still remain you can delete them now. Cheers Dan UG Bot on "How do you uninstall the CRM 3.0 MSDE instance?" http://forum.crmreports.com/topic/how-do-you-uninstall-the-crm-30-msde-instance#post-1914 Wed, 10 Sep 2008 16:06:33 +0000 UG Bot 1914@http://forum.crmreports.com/ Newsgroup subject: Re: Uninstalling the CRM 3.0 Laptop Client Archived from: microsoft.public.crm Author: Yeshua Hello Dan, Thanks for replying. Wish it was that easy. What if they are running other programs that need the SQL services? I just want to make sure I remove only the CRM MSDE instance and not interfere with the other programs that still need SQL. UG Bot on "How do you uninstall the CRM 3.0 MSDE instance?" http://forum.crmreports.com/topic/how-do-you-uninstall-the-crm-30-msde-instance#post-1889 Wed, 10 Sep 2008 13:53:29 +0000 UG Bot 1889@http://forum.crmreports.com/ Newsgroup subject: Re: Uninstalling the CRM 3.0 Laptop Client Archived from: microsoft.public.crm Author: Dan Hi, Once removing the SQL services etc, you can just delete the databases as regular files. Dan UG Bot on "How do you uninstall the CRM 3.0 MSDE instance?" http://forum.crmreports.com/topic/how-do-you-uninstall-the-crm-30-msde-instance#post-1868 Wed, 10 Sep 2008 08:15:08 +0000 UG Bot 1868@http://forum.crmreports.com/ Newsgroup subject: Uninstalling the CRM 3.0 Laptop Client Archived from: microsoft.public.crm Author: Yeshua How do you uninstall the CRM 3.0 MSDE instance (database) from the laptop? I went in into Add and remove programs and uninstalled the CRM laptop client. I also went to uninstall the MSDE that was installed when i installed CRM 3.0 Laptop Client. I went into Add and Remove programs and selected SQL Server 2005 and clicked on change. Then under Remove SQL Server 2005 instance components I select the CRM:Database Engine and click next. When it's finished I look in the Microsoft SQL Server folder MSQL1, MSQL, Data and the databases are still there. What are the steps to completely remove CRM Laptop Client and the CRM Databases? UG Bot on "Trying to find the system views in CRM 4.0" http://forum.crmreports.com/topic/trying-to-find-the-system-views-in-crm-40#post-1777 Mon, 08 Sep 2008 17:15:50 +0000 UG Bot 1777@http://forum.crmreports.com/ Newsgroup subject: CRM 4.0 System Views Archived from: microsoft.public.crm.deployment Author: msnews.microsoft.com Hello, I'm trying to find the system views such as "active contacts" or "No Orders - Last 6 Months" in the database from CRM. It must be either views or filters... but they must be somewhere in the database. I have no clue where it is and can't find it. Could anyone please give me a little hint? Greets Falko UG Bot on "Integration set up between Great Plains companies & a propriety DB, using Scribe" http://forum.crmreports.com/topic/integration-set-up-between-great-plains-companies-038-a-propriety-db-using-scribe#post-1776 Mon, 08 Sep 2008 17:14:42 +0000 UG Bot 1776@http://forum.crmreports.com/ Newsgroup subject: Re: Replicating Production data in Test environment Archived from: microsoft.public.crm.deployment Author: RLB Thank Matt, they are using the MSDN 10 licenses in the test environment so I think assigning all the accounts to a single user once moved is are only option. If the redeployment is uses would that leave the production environment inoperable? What have you seen other customer do to truly replicate environments? Thank you UG Bot on "Integration set up between Great Plains companies & a propriety DB, using Scribe" http://forum.crmreports.com/topic/integration-set-up-between-great-plains-companies-038-a-propriety-db-using-scribe#post-1759 Sat, 06 Sep 2008 15:59:58 +0000 UG Bot 1759@http://forum.crmreports.com/ Newsgroup subject: Re: Replicating Production data in Test environment Archived from: microsoft.public.crm.deployment Author: Matt Parks Redeployment can definitely be used to move between domains. The key though is ensuring you have enough AD Users to map all the prod users to when you run the Wizard. -- Matt Parks MVP - Microsoft CRM UG Bot on "Integration set up between Great Plains companies & a propriety DB, using Scribe" http://forum.crmreports.com/topic/integration-set-up-between-great-plains-companies-038-a-propriety-db-using-scribe#post-1718 Fri, 05 Sep 2008 17:24:06 +0000 UG Bot 1718@http://forum.crmreports.com/ Newsgroup subject: Replicating Production data in Test environment Archived from: microsoft.public.crm.deployment Author: RLB our customer is looking to replicate there production data dynamics 3.0 into a Q/A we already have an existing Q/A environment set up but the data is outdated. We have an integration set up between 8 Great Plains companies & a propriety DB, using Scribe. What would be the best way to mirror the data? It would be simple to copy the Great Plains database; I think we could update the Scribe Keycross reference two way table. But the CRM data is not as transportable. Would using the CRM redeployment be an option? I have used this one before but only to move the database server within the same domain. We would be moving the CRM database to another domain and still leave the existing database in production. UG Bot on "Keep user data upon reinstalling CRM 4.0" http://forum.crmreports.com/topic/keep-user-data-upon-reinstalling-crm-40#post-1660 Thu, 04 Sep 2008 18:58:32 +0000 UG Bot 1660@http://forum.crmreports.com/ Newsgroup subject: Re: Reinstalling CRM 4.0 but preserving data - HELP, PLEASE! Archived from: microsoft.public.crm Author: Rob Mottram We have done this in the passed. We always did it this way, which did work! Backup everything (Just to be safe!) Removed CRM4, but did nothing to the SQL databases. Reinstalled CRM4, creating a dummy organization, with a different name to the one we want. Once CRM4 is installed, open Deployment Manager Click on Orgnizations, then click import. At this point you can point to the SQL database with your organization in it. This will put your organization into CRM. There is also a know bug with this, to do with workflow. Have a look here. <a href="http://support.microsoft.com/kb/950680/en-us" rel="nofollow">http://support.microsoft.com/kb/950680/en-us</a> Hope you manage to resolve your issue Rob UG Bot on "Keep user data upon reinstalling CRM 4.0" http://forum.crmreports.com/topic/keep-user-data-upon-reinstalling-crm-40#post-1624 Wed, 03 Sep 2008 19:13:46 +0000 UG Bot 1624@http://forum.crmreports.com/ Newsgroup subject: Re: Reinstalling CRM 4.0 but preserving data - HELP, PLEASE! Archived from: microsoft.public.crm Author: Aamir Bashir Edward Might be someone has other saying but i always use the way you described. It works perfect. ------ Aamir Blog : <a href="http://mscrmsupport.wordpress.com/" rel="nofollow">http://mscrmsupport.wordpress.com/</a>