|i have not had any luck using this method. it was really simple on SQL6,
|however SQL7 seems to require that the backup file being restored must
|have come from the same machine it's being restored to. i've even tried
|to create a temp backup file, replace it with a new backup file that
|includes the new data, and then try to restore that but somehow SQL7
|knows that it's different and won't use it.
If the file system setup varies from machine to machine, you need to make
sure you change the paths ( options tab of restore window ) when doing a
restore. For example my development machine might keep files C:\mssql\...
but when I move it to the production server it might keep files in
Z:\mssql\...
____________________________________________
Sean Brown [EMAIL PROTECTED]
http://www.imagicians.com/
"Either way you get your dog back."
-J.Lieberman
____________________________________________
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
