Posted by Erland Sommarskog on 12/05/03 11:32

Branco Medeiros (branco.medeiros@gmail.com) writes:
> Erland Sommarskog wrote:
><snip>
> Looks like you have run out of disk space.
><snip>
>
> Nope, plenty of space. The backup file is 200 MB and the HD where it's
> being restored to still has 19.7 GB of free space.

If you do an sp_helpdb on the database in SQL 7, what do you see for
autogrow?

If you comes as far so you can do sp_helpdb on the database in SQL 2000,
what do you see for autogrow there?

I would expect autogrow to be turned off completely, or possibly be set
to some completely wacko value like 20 GB.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]