October 3, 2008 at 8:09 am
Can you alter a table in a database that is mirrored on SQL 2005 while mirroring is active or do you need to suspend it to alter the table?
October 3, 2008 at 11:54 am
That should be ok.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 3, 2008 at 1:40 pm
Sure you can. You can do pretty much anything to the DB while it's being mirrored. The only exception I've found is removal of files / filegroups.
One caution: high transaction operations (for example moving large amounts of data) can cause mirroring to fall seriously behind. Most of the time I've found that the mirror catches up OK butit is something to watch.
October 4, 2008 at 11:26 am
Sure you can there is no restrictions on the database operations.
Please let us know if you are facing any issues....
Thanks -- Vj
October 6, 2008 at 12:24 am
how can you do that when the mirror database cannot be read because it is non - recovery
October 6, 2008 at 12:31 am
with db mirroring, every action on the primary database is sent to the mirror db.
It is not active, so no one else can tamper with it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply