Before you jump into backup and restore mode, check out this gem from Mike S. where he shares his method for migrating production data onto his development server for his nefarious purposes:

"a.       Deploy SmartObjects on New Server

 b.      Go to SQL and Import Data from Old SmartObject DB to new SmartObject DB using the Copy Table option…

 c.       Select the Tables you want to copy (If you have used AutoNumber’s anywhere, make sure you go into the options and allow Identity Insert)"

It stands to reason that this method can successfully be applied to clustered environments also.

It is possible to use the backup/restore option, but with just average results.

---

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.