Add Datafile to Standby/Read-Only Database

Question

Post reply

Add Datafile to Standby/Read-Only Database

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

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

Saronabound Mr or Mrs. 500 Points: 525 More actions · Answer 1

After I pause, log shipping, take the t-log backup, a.trn,

On Secondary Instance

RESTORE LOG A_Log

FROM DISK='E:\MSSQL\BACKUP\a.trn'

WITH MOVE 'a2' to 'G:\MSSQL\Data\a.ndf',

NO RECOVERY

Start Log shipping back up.

One other question, for now:w00t:

Will all the data from the logs that will now be applied, be placed in the new data file, since the drive thennew data file is basically empty and drive for the original data file is almost full.

Keith

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Best thing you could do, test this in a test environment to be sure it does what you expect. If both files are in the same file group I would assume that when one file becomes full that data and indexes would begin to file the second file. I have never done this personally, so again, test it in a test environment.