Problem with Restore Table and Restore Database 
Author Message
 Problem with Restore Table and Restore Database

My Restore problem is with a SQL 6.5 Server.  I am trying to restore one
table back into a database.  The restore start correctly but then a Error
message pops up and says "The table TableName cannot be restored because
it contains text or image Columns."  Why can't I restore a table with text
or image columns?  How can I restore a table with text or image columns?
Then I said well this is a small database 190 Mb.  Why not create another
database on same server and restore the whole database.  Created small
database 500 Mb just to be safe.  Then try to restore and message pops up
"[SQL SERVER] data on dump will not fit into current database.  Needs 3152
mbte database."  This is more than ten times the size of the current
database.
Why do I need such a database?  Can I restore the whole database without
needing this much space?  My server doesn't have 3 gigabytes left to
allocate
for this database.

Thanks,

Marty



Fri, 25 Jan 2002 03:00:00 GMT
 Problem with Restore Table and Restore Database

Have you tried running DBCC Checkdb on the database in question?

Jerry

Quote:
> My Restore problem is with a SQL 6.5 Server.  I am trying to restore one
> table back into a database.  The restore start correctly but then a Error
> message pops up and says "The table TableName cannot be restored because
> it contains text or image Columns."  Why can't I restore a table with text
> or image columns?  How can I restore a table with text or image columns?
> Then I said well this is a small database 190 Mb.  Why not create another
> database on same server and restore the whole database.  Created small
> database 500 Mb just to be safe.  Then try to restore and message pops up
> "[SQL SERVER] data on dump will not fit into current database.  Needs 3152
> mbte database."  This is more than ten times the size of the current
> database.
> Why do I need such a database?  Can I restore the whole database without
> needing this much space?  My server doesn't have 3 gigabytes left to
> allocate
> for this database.

> Thanks,

> Marty




Fri, 25 Jan 2002 03:00:00 GMT
 Problem with Restore Table and Restore Database
Jerry,

I didn't run DBCC Checkdb until you suggested it.  I ran
it both on Source Database (Originally Database I want
to restore one table to) and Target Database (Database
Created to restore all Source database to).  I didn't
receive any weird messages.  I know that the table I want to restore does
contain text columns.  I have a
few columns that are type char(255).  I saved the
DBCC output.

Marty

Quote:
> Have you tried running DBCC Checkdb on the database in question?

> Jerry


> > My Restore problem is with a SQL 6.5 Server.  I am trying to restore one
> > table back into a database.  The restore start correctly but then a
Error
> > message pops up and says "The table TableName cannot be restored because
> > it contains text or image Columns."  Why can't I restore a table with
text
> > or image columns?  How can I restore a table with text or image columns?
> > Then I said well this is a small database 190 Mb.  Why not create
another
> > database on same server and restore the whole database.  Created small
> > database 500 Mb just to be safe.  Then try to restore and message pops
up
> > "[SQL SERVER] data on dump will not fit into current database.  Needs
3152
> > mbte database."  This is more than ten times the size of the current
> > database.
> > Why do I need such a database?  Can I restore the whole database without
> > needing this much space?  My server doesn't have 3 gigabytes left to
> > allocate
> > for this database.

> > Thanks,

> > Marty




Fri, 25 Jan 2002 03:00:00 GMT
 Problem with Restore Table and Restore Database
Have you alter or added a table since the
backup was done? If you have the internal table
id's may be different and a restore to this database
will not be possible, you will have to restore into
anther database, create the table a new and transfer the
data.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.



Fri, 25 Jan 2002 03:00:00 GMT
 Problem with Restore Table and Restore Database
Thanks for your response but I have not altered or added to the table
since the backup was done.  I am able to transfer the source database
to the destination database without problem.

Marty

Quote:

> Have you alter or added a table since the
> backup was done? If you have the internal table
> id's may be different and a restore to this database
> will not be possible, you will have to restore into
> anther database, create the table a new and transfer the
> data.

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.



Fri, 25 Jan 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Single Database Restore / Single DBSPACE RESTORE

2. Calc members wacked from cube after restoring cube save/restore of database

3. Restoring a database using the RESTORE (T-SQL)

4. Database restore error - cannot restore

5. Urgent Restore problem with SQL Server's restore utility

6. Restoring databases to another server from restored files

7. Restore database error - unable to restore

8. Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published

9. Problem Restoring an SQL 7.0 database to SQL 2000 - Database Not Published

10. Problems Restoring a database - Database in Use

11. attempt to restore, said db was dumped under diff sort order, how to restore it

12. restore all user defined user role and logins after restore


 
Powered by phpBB® Forum Software