Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2005 not enough storage is available to complete this operation

Status
Not open for further replies.

thisisboni

Programmer
Jun 1, 2006
113
US
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 would suggest....

Script the database without the data.
Create the DB on SQL2005
Create a linked server from SQL2008 to SQl2005.
Copy the data through the linked server



-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Run this command on the destination server:

xp_fixeddrives

That will show you how much free space is on each drive.

Check the free space on the drive that your file is being copied to.

Then right click on the instance name, go to Properties, Database Settings tab. Look at the default location where databases are created. Then look at the space available on those drives (refer back to the results from xp_fixeddrives). This will let you know if there is enough room to restore the database.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
SQLBill,

He's not trying to restore. He scripted the DB (with data) because he's trying to move from SQL2008 to SQL2005.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
George,

I took his "when I tried to open it in SS2005" to be that he is trying to run the script there to 'restore'/create the database on SS2005 with all the data.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
What machine are you running SSMS on when you open this file? How much memory does that machine have? Have you tried running this SQL Script via sqlcmd on the server's console?

Is the sql script local on the machine that you are running SSMS on?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top