November 22, 2002 at 5:57 am
I have been looking on the internet but I couldn't find a definitive answer to this question. Maybe somebody can help.
We have a database that uses log shipping. If we add a filegroup to this database will logg shipping break because of this ? or will the same filegroup (assuming the same direcory stucture exists) be created automatically on the standby server.
November 22, 2002 at 8:17 am
I can't give you a definite answer but I would be 90% sure to day it would break. You will need to apply a backup after the new filegroup is added and then start the shipping again
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 27, 2002 at 3:18 am
Well because to KNOW is better than to THINK, I tested this situation.
And Guess what......
As long as the Drives/directories on both servers are the same everything works fine. No problem encountered.
The Filegroup was created on the standby server. All the tables in that filegroup were created so it works.
So the statement in the knowledge base Q286280 is really true !
Edited by - well0549 on 11/27/2002 03:19:25 AM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply