January 19, 2011 at 12:53 pm
Well, I'm calling it a time-out. What I am going to or would like to do is the following.
1. Create a mirror instance from my primary to a secondary server (this is easy and already done)
2. What I need to do is ship the server to a hosting facility, it will probably be off line for 6 days. When they get the server online I would like to reestablish the mirror. It's internal address will stay the same and DNS will not change. Does anyone know if this is possible or if with the mirrored instance being off line for that many day's will it fail to reestablish and sync the data?
or does anyone out there in SQL land know if there is a timeout on the mirror or if it just keeps pinging the other server.
January 19, 2011 at 1:15 pm
My 2ct...
I think you will need to pay attention regarding your load in the off line timeframe.
Make sure your log file(s) is big enough and your server has enough place to cope with it.
In theory it seems possible, however .... tell your system what you know.
SQL2005 doesn't compress it shippings for mirroring, so depending on the volume to be processed to get in sync, it may generate network load and consume considerable amount of time to process.
In stead of having mirroring handling your timeframe worth of transaction load, it may be worth considering the scenario to just prepare for mirroring, leaving the db with norecovery restores and when it is ready at the new site, just ship over zipped incremental log backups and restore those so your db is in a state it can commence mirroring and you can complete the rest of the mirroring configuration.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply