July 26, 2007 at 12:26 am
i am going to configure sql server mirroring
i got appeared this message
Msg 1469, Level 16, State 1, Line 2
Database mirroring cannot be enabled because the "CMSNaveed" database is an auto-close database on one of the partners.
although i have taken a coplete backup and log backup as well
and restored by Norecovery option
My Principal name is CMSNAVEED
plz help me
July 26, 2007 at 12:49 am
Hi
Auto-close means that database will shut down after the last connected user has exited. U will disable this. U can do this by taking database properties\options.
This is a feature that will not be there in future SQL Server versions , so avoid using this.
"Keep Trying"
July 26, 2007 at 1:24 am
ohhh sir your great
i got the actual result
Thanks
January 12, 2017 at 8:06 am
Nido786 - Thursday, July 26, 2007 1:24 AMohhh sir your great
i got the actual result
Thanks
Thanx,
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply