
February 18th, 2004, 12:16 AM
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Sydney Australia
Posts: 17
Time spent in forums: 4 m
Reputation Power: 0
|
|
|
backup 7.0 and restore into 2000 data loss
Hello fellow SQl Serer 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
Matt
|