- Restoring SQL from backup
- Posted by Adam Rivera on March 31st, 2006
On the December demo image from Microsoft, there's a database backup for the
MSCRM database. I've been working to see if a data import from the Scribe
tool would work and have been deleting small amounts of data from CRM
manually thru CRM. Now that I'm importing all the data (roughly 12,000 rows
in multiple tables, not too much), I'm looking for a way to quickly clear
out the data and restore back to the demo data (which is there for reference
purposes).
I thought using SQL 2005 restore would work, but the database is constantly
locked. Any tips on how to restore the database?
- Posted by Adam Rivera on March 31st, 2006
Victory achieved by shutting down the CRM IIS Website and the CRMAppPool,
then restoring.
On 3/31/06 10:02 AM, in article
C052AEAC.DF0%Adam.Rivera@lightindustries.com, "Adam Rivera"
<Adam.Rivera@lightindustries.com> wrote:
- Posted by Joe L on March 31st, 2006
You could also use a sql script to kill all process running against the
database you want to restore right before the restore.
CRM will reconnect as soon as the databases are available again.
"Adam Rivera" <Adam.Rivera@lightindustries.com> wrote in message
news:C052AEAC.DF0%Adam.Rivera@lightindustries.com. ..
