Add new filegroup and log shipping

[timscronin]

We have sql 2000 server at a remote site that log ships to a standby server at the site, and back here to corporate. For performance we are adding a new RAID array to the remote servers along with a new file group for indexes. The server back here is older and we can't add this RAID. For log shipping purposes, what if anything might happen to this server when the filegroup is added. We are going to be using this filegroup for indexes

 

[mrdenny]

The log shipping will break when it gets to the transaction log that adds in the new file group. You will need to manually restore this transaction log file using the with MOVE command to redirect the new filegroup to an available drive on the destination SQL Server.

I'm not sure how the Microsoft Log Shipping will take you manually having to restore a file. You may need to resetup the log shipping.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

Tim,
I've done this many times. Just disable the log shipping jobs. (the TLog backup on the Source and the COPY and Restore on the destination.) Restore a the database like Denny said using with MOVE. Then restart you jobs. You shouldn't have any problems

- Paul
- If at first you don't succeed, find out if the loser gets anything.