SQL space issue

[cellspam]

Hi all,
im traing to make a restore from a db on sql 2005
and i have the following error.
The table i want to restor is 11gb.
The free space in the hdd is 47gb.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'SQL'. (Microsoft.SqlServer.Smo)
For help, click:

http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'F:\' to create the database. The database requires 160741457920 additional free bytes, while only 47436738560 bytes are available. (Microsoft.SqlServer.Smo)
For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

 

[drlex]

The error message is claiming that the restore requires 149.7GB. You say that the table you want to restore is 11GB; is it possible that the database you are restoring is 150GB?

soi là, soi carré

 

[mrdenny]

You can't restore just a table, unless you are using a third party tool. You have to restore the entire database to its original size in order to get the table out of it.

Denny
MVP
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)

My Blog