Posted by Erland Sommarskog on 06/17/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

• Next in forum: Re: SQL Server Msg 1105, Level 17, State 2, Line 1
• Prev in forum: Re: SQL Server Msg 1105, Level 17, State 2, Line 1
• Thread view: Re: SQL Server Msg 1105, Level 17, State 2, Line 1

[Reply to this message]