locked
Restoring a database from snapshot folder RRS feed

  • Question

  • Hi,

    I need to restore a sql server 2000 database which does not have any backups apart from a snapshot folder which contains some .bcp, .IDX and .Sch files. (there was a transactional replication setup on this database at some point and the snapshot folder is still there.)

    Is this possible? any help will be highly appreciated.

    thanks,

    Alind

    Monday, September 11, 2006 2:19 PM

Answers

  • sure it's possible, create a database, run the .sch files, bcp/bulk insert the .bcp files into the tables, then run the .idx files.  Not sure if there are column or row delimeters, you can open one of the bcp files up and see if there are any.
    Tuesday, September 12, 2006 4:32 AM
    Moderator

All replies

  • sure it's possible, create a database, run the .sch files, bcp/bulk insert the .bcp files into the tables, then run the .idx files.  Not sure if there are column or row delimeters, you can open one of the bcp files up and see if there are any.
    Tuesday, September 12, 2006 4:32 AM
    Moderator
  • thanks Greg for your reply,

    can you please elaborate what you mean by run the .sch file? run the .idx files?

    an example would be great.

     

    thanks again.

    Alind

    Sunday, September 24, 2006 10:10 PM
  • These are the TSQL files located in the snapshot folder that the agents use to create the schema at the subscriber.  .sch is schema file (create table statements), .idx is index file (create index statements), .trg is trigger file (create triggers), etc. etc.

    Sunday, September 24, 2006 11:58 PM
    Moderator