Hello fellow SQl Server users
Has any body suffured data loss backing up an SQL Server 7.0 data store and restoring into a 2000 instance. I am stressed after loosing a considerable amount of data during this process. Until this event I considered myself failry DBA savy. My actions are as follows: An Enterprize Manager back up producing a 60mb .bak file from a clients production server (7.0 instance). After backing up my local development copy (3mb .bak file running a 2000 instance) I restored the 60mb .bak file using query analyser with the following command:
------------------------------------
RESTORE DATABASE mhqohs
FROM DISK = 'C:\Inetpub\wwwroot\MHQnew\ohs\data\mhqohs.bak' WITH
     move 'mhqohs_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mhqohs_Data.mdf',
     move 'mhqohs_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\mhqohs_log.ldf'
-------------------------------------
The results of this back up was a data store containing less data than before the restore, ah ah ah how could this happen??
The log files in MSSQL/DATA did did not grow in size, they remained 1.8ish mb. Also, my original dev datastore has additional tables to the live datastore. This, and query analyser confirming a successfull restore tells me a restore took place - amy ideas on where the data went???

Thank you in advance


Wind id your friend
Matt

__________________
Wind is your friend
Matt