Post reply

Applying a snapshot that was ftp''d to me.

  • July 11, 2007 at 10:49 am

    #103388

    Any assistance would be greatly appreciated.

    This task has been handed to me since I'm our company's SQL "expert" - never mind that I've never set up replication before. Anyway...

    I am running MSSQL 2000, SP4 (vendor is also supposed to be MSSQL 2000, SP4)

    A vendor has sent me, via ftp, a snapshot of his database. And he will begin sending me updates also via ftp. I have his file, named: snapshot.cab.

    How do I apply this snapshot to my server? I can set up replication from one of my databases to another of my databases (and can make my own file named: snapshot.cab), but I cannot seem to convince Enterprise Manager to let me apply the vendor's file.

    Please let me know if you need any additional information.

    Kindest Regards,

    --SF

    (SELECT COALESCE(Phlogiston,Caloric,DarkMatter) as Construct FROM Science.dbo.Theory)

  • July 12, 2007 at 7:42 am

    #718970

    From the ".cab" externsion, this is probably a cabinet file. WinZip should be able to extract the file(s) in the cabinet. I think you'll find a database backup in there that you can restore and set up as a subsciber.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • July 13, 2007 at 9:47 am

    #719347

    The .cab file is the file generated by a snap shot for replication that uses http://ftp.  You will need to set up a subscription on your sql-server to put this information into a database. You will need to work with the person who provided the snap shot because you will need some information about the server that is the source of the publication.

    Read up on replication in BOL (books on line)

    I would guess that the person that provided you with this information expects you to set up an anonymous pull subscription but you will have to check with them on that.

    Steve

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply