Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (412 entries) see
or www.ntfaq.com/sql.html (+ ntfaq download)
In MS SQL 6.5, when restoring a database to another server that had expanded
more than once, you had to execute the stored procedure
"sp_help_revdatabase" to ensure that the page sizes were the same.
However, in MS SQL 7.0, the stored procedure "sp_help_revdatabase" is only
included for backward compatibility.
Can I restore a MS SQL 7.0 DB from one server to another server even if the
file sizes of the databases do not match?