thisisboni
Programmer
Hi:
I need to copy a database from SQL Server 2008 to SQL Server 2005. Since '08 .bak cannot be restored in '05 I have created a .sql file by 'Generate Scripts' with Data option. This file is about 12Gb.
When I'm trying to open this in SQL Server 2005 I get this message -
not enough storage is available to complete this operation
What do I need to do in order to open this file in SQL 2005 ?
Thanks
I need to copy a database from SQL Server 2008 to SQL Server 2005. Since '08 .bak cannot be restored in '05 I have created a .sql file by 'Generate Scripts' with Data option. This file is about 12Gb.
When I'm trying to open this in SQL Server 2005 I get this message -
not enough storage is available to complete this operation
What do I need to do in order to open this file in SQL 2005 ?
Thanks