Printable View
We are looking into sql 7.0 and would like to know how it handles excessively sized databases. If we restore a 6.5 database into a db on 7.0 will it automatically resize to free up disk space or will it only work for new databases which have install scripts run on it.
You can`t restore a 6.5 database into a 7.0 server. The system tables, page size, and a whole host of other things are incompatible. All 7.0 databases do automagically resize to give back any disk space.
On 6/25/98 8:15:58 AM, russell thomas wrote:
>
We are looking into sql 7.0 and would like to know how it handles
> excessively sized databases. If we restore a 6.5 database into a db on 7.0
> will it automatically resize to free up disk space or will it only work for
> new databases which have install scripts run on it.
Russell,
As the previous reply stated you cannot restore a 6.5 database to a 7.0 because they are structurally dissimilar. There is a utility for doing the port however so it probably won`t be a big deal in any case.
SQL Server 7.0 lacks Devices (a holdover from the Sybase SQL Server days)! It uses NT facilities instead making it faster and amenable to new features such as automatically growing and shrinking the disk usage to dynamically fit the data.
You can, for example, have a database that tracks sales over a single year. As the year progresses more and more data is added so the database can automatically grow (you control the increments). At the end of the year when the data is cleaned off to begin the subsequent year the database can shrink and free up disk resources. (You can also turn off the automatic facility and size everything manually if you desire.)
Tom