Hi all,
I had another thread that I didn't want to overload with too many questions, so here is another log-shipping question:
Can I perform dbcc ShrinkFile on either database in a log shipping setup without having to backup/restore and restart the log shipping? If not, are there any other common maintenance tasks (aside from backup of course) that I am restricted from doing on the primary database when I have log shipping set up? We're undergoing this for the first time and would like to know the gotcha's and all the little things that we may not be able to do anymore when we have the remote site set up and are depending on them to be perfectly in sync.
Thanks very much,
--Jim
I had another thread that I didn't want to overload with too many questions, so here is another log-shipping question:
Can I perform dbcc ShrinkFile on either database in a log shipping setup without having to backup/restore and restart the log shipping? If not, are there any other common maintenance tasks (aside from backup of course) that I am restricted from doing on the primary database when I have log shipping set up? We're undergoing this for the first time and would like to know the gotcha's and all the little things that we may not be able to do anymore when we have the remote site set up and are depending on them to be perfectly in sync.
Thanks very much,
--Jim