800m backup wants 7G 
Author Message
 800m backup wants 7G
Still trying to restore a 6.5 backup.  I created a new db, told EM to restore s.dat to it and got
error: "Data on dump will not fit into the current database.  Need 7Gig database"
s.dat is only 780Meg.  I am guessing the original db had 7G allocated?  The new box only has 6G free.  

Carl Karsten

--
  http://www.***.com/



Tue, 27 Sep 2005 15:46:43 GMT
 800m backup wants 7G

Restore it on another box with enough space, modify the filesize using ALTER
DATABASE, then create another dump.


Quote:
> Still trying to restore a 6.5 backup.  I created a new db, told EM to

restore s.dat to it and got
Quote:
> error: "Data on dump will not fit into the current database.  Need 7Gig
database"
> s.dat is only 780Meg.  I am guessing the original db had 7G allocated?

The new box only has 6G free.
Quote:

> Carl Karsten

> --
>  http://www.personnelware.com/carl/resume.html



Tue, 27 Sep 2005 15:48:06 GMT
 800m backup wants 7G
To add a little bit of information to Aaron's absolutely correct response, I
believe that SQL Server 6.5 required that the database you're restoring to
be at least as big as the database that was backed up. So yeah, you need to
find more space.

Hope this helps,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.



Quote:
> Restore it on another box with enough space, modify the filesize using
ALTER
> DATABASE, then create another dump.



> > Still trying to restore a 6.5 backup.  I created a new db, told EM to
> restore s.dat to it and got
> > error: "Data on dump will not fit into the current database.  Need 7Gig
> database"
> > s.dat is only 780Meg.  I am guessing the original db had 7G allocated?
> The new box only has 6G free.

> > Carl Karsten

> > --
> >  http://www.personnelware.com/carl/resume.html



Tue, 27 Sep 2005 18:26:27 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. 800M tempdb full with two query

2. SQLZIP - Beta Testers wanted for backup compression utility

3. Beta Sites Wanted - Online Backup

4. Unix backup script wanted

5. ORACLE: Backup Suggestions Wanted (SUMMARY-LONG)

6. Ap 5.2.6 nat Tape Backup Wanted

7. newbee wants to make backup

8. backup and recovery tools for Sybase wanted

9. ORACLE: Backup suggestions wanted

10. Wanted: FoxPro/C (C++) Programmer wanted (Contract Position)

11. Wanted: Paradox 7.0 for windows 95 Consultant wanted

12. US-KY **** WANTED ***dead or alive ***INFORMIX PROGRAMMERS****WANTED


 
Powered by phpBB® Forum Software