I have scripted out a SQL2008R2 DB in order to recreate the DB as a 2005 version. I ran the script with no issues, but when I run the script for the 2005 DB I receive an "Out of Memory" error. How much memory do I need to complete this as it is an urgent matter to get htis back to 2005 for our client.
The DB is 210MB. I deleted the Log file so that is under a meg. The script is 240MB itself.
I just need to know how I can get this script run to create my sql2005 DB.