How about this? http://yrushka.com/index.php/database-recovery/restore-sql-2008-r2-database-on-sql-2008-sp1-instance/
Christopher Bodnar Enterprise Architect I, Corporate Office of Technology:Enterprise Architecture and Engineering Services Tel 610-807-6459 3900 Burgess Place, Bethlehem, PA 18017 christopher_bod...@glic.com The Guardian Life Insurance Company of America www.guardianlife.com From: Kevin Lundy <klu...@gmail.com> To: "NTSysADM@lists.myITforum.com" <NTSysADM@lists.myitforum.com> Date: 12/13/2013 03:27 PM Subject: [NTSysADM] SQL Gurus - migrate to a lower version Sent by: listsad...@lists.myitforum.com Hi All I have a client that upgraded a database from 2008 to 2008 R2. It took a while, but eventually their primary application proved to be incompatible. They get a fail because they didn't read the compatibility guide and didn't adequately test. But that is why they are now a client. I know you can't restore to an older version. I've found a few references to using Enterprise Manager "Generate Scripts" with some advanced options. I've tested on some simple databases. Has anyone done this on a fairly large complex database? Aware of any constraints, issues, etc? How about alternative methods or tools? I've seen a couple of references to using Redgate tools - I have a call into them. Thanks Kevin ----------------------------------------- This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you.
<<image/jpeg>>