Is there an easy and supported way to delete test data only and preserve
customizations (other than manually deleting in MS CRM)?

Basically I'd like to go into SQL Server and do a SQL TRUNCATE TABLE
tablename on some of the tables in the "Organization_name_MSCRM.mdf" to
clear out these tables.

My concern in that approach is that I have not done it in MS CRM and don't
know what I don't know in terms of problems that this may cause.

Yeah, using SQL was what I wanted to do too, but the
supported way to is to restore a backup of the original
DBs before data was added. "No SQL" is one issue but
another is related to the distribution DB which is being
written to as well.

Linda Dienberg
Microsoft CRM
Certified Instructor/Professional
ICS Advantage
630-566-8386

Go to Deployment Manager -> right click -> export
customizations. In this way you can preserve the
customizations you've done.

Exporting/Importing the XML will only preserve/restore any customizations
such as forms, views and perhaps mappings, etc. It will not preserve/restore
any data or database structures.

--
Rich Phan

"innab" <innab@nur.com> wrote in message
news:07bb01c36ca8$e07845f0$a001280a@phx.gbl...

That's true, but still, innab's advice is not bad.

When we do backup/restores we always export the
Customization XML (and also workflows). We keep the DB
backups and the exports and keep them all together in one
folder. It really isn't necessary, but it's just nice to
have a complete point-in-time package.

Linda Dienberg
Microsoft CRM
Certified Instructor/Professional
ICS Advantage
630-566-8386

That's a good practice. There's less headaches when you need to go back to
an earlier version, and the other pieces such as Active Directory users and
organizations could probably be manually modified if required.

--
Rich

"lindad" <lindad@icsadvantage.com> wrote in message
news:02be01c36cd0$003cae40$a401280a@phx.gbl...