If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SQL Server 6.5 data device

I understand that to restore a SQL Server 6.5 database, the destination database must be at least the size of the source database [data + log]. Just for the sake of it, I created the destination database with a data device of 1Mb and a separate log device of 99Mb. The source data device was 80Mb with a 20Mb log device. The restore actually worked and I can't understand why it didn't run out of data device space. I just wanted to see what sort of error message would appear. There is definitely more than 1 Mb of data. The data all seems to be present but I don't understand where it is all stored. I appreciate that this configuration was purely experimental, but can anyone explain where the data would have been restored to?