Post reply

shrinking data file on primary server does not shrink data file on logshipping server

  • June 5, 2018 at 10:43 pm

    #369325

    Recently I developed a script to move user objects to newly created data file, then shrink the original file (command: DBCC SHRINKFILE (N'DataFile' , 100)) to reduce the disk space usage. however I found:

    1. on the logshipping server, the second data file is created.

    2. the original data file is not changed. though the data file on the primary server has shrunk to 100MB

    We developed a tool ourself to do the logshipping, e.g. sending all trn files to another data center and restore the trn file, the databases in DR site remains in restoring status.

    Does anyone knows what prevent the data file to be shrunk at DR site?

    Thanks,

  • June 24, 2018 at 6:55 pm

    #1995083

    I restored it to standby mode which shrink the data file successfully.

    (no operation can be performed in norecovery mode)

  • June 25, 2018 at 2:19 am

    #1995096

    i1888 - Sunday, June 24, 2018 6:55 PM

    I restored it to standby mode which shrink the data file successfully.

    (no operation can be performed in norecovery mode)

    did you solved your problems? how  did you move user objects to newly created data file?

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

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