October 12, 2011 at 8:05 am
Hi
I have sql 2008 Server with Mirroring with automatic failover
Database name is symantran
I want to change the name from symantran to Symantran.
Only the letter "s" I am chaging to "S"
What are the steps to be taken ? Need to break mirroring ?
October 13, 2011 at 5:55 am
Hi Akkare,
You're going to have to break the mirroring, restore the db as 'Symantran' (in recovery) before resuming mirroring as you normally would do.
Cheers
Vultar
October 20, 2011 at 1:26 am
Always remember no changes to the database properties in a mirroring session.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
October 20, 2011 at 6:28 am
why? Are you using a case sensitive collation?
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply