I have a machine running SQL 7.0 service pack 4 when I restore a test
database from a live database I get an error saying there is not enough
space on the drive. The database is roughly 2 gigs in size I have over
29 gigs free on the drive. I resized the test database so it was just as
large as the live database. I have even turned allow grow back on the
test database. Still I get the error not enough space on drive.

Has anyone run into this problem before?


Thanks
John

MS Sql Server LazyDBA home page