Post reply

How to check the snapshot location working directory

  • January 17, 2017 at 7:56 am

    #317777

    Hello,

    I need to search the folder which contains all the replication snapshot details say idx, prefetch, schm files etc. 

    Is there any query available to get the details?

    Thanks.

  • January 17, 2017 at 5:32 pm

    #1923307

    SQL-DBA-01 - Tuesday, January 17, 2017 7:55 AM

    Hello,

    I need to search the folder which contains all the replication snapshot details say idx, prefetch, schm files etc. 

    Is there any query available to get the details?

    You can get the working_directory querying MSdistpublishers in msdb. You have to drill down a bit in this directory as you can have different publications, you can have multiple snapshots and the folders are created using a timestamp name. You'll see what I mean when you look in the working directory.

    Sue

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

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