August 10, 2015 at 5:04 am
what is meant when the database in standby/singleuser/readonly mode in log shipping.
can we check how and when did this change happen
Thanks
August 10, 2015 at 6:26 am
Standby mode in log shipping is a very nice feature that allows you to run read-only workloads from the log-shipped secondary. Someone set it manually or much more likely it was set when log shipping was constructed.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
August 10, 2015 at 6:48 am
I created this in standby/readonly.. but its changed to standby/ singleuser/ readonly..
how to do i check who/how was this change done
August 10, 2015 at 7:42 am
You can try the SQL error log and see.
Regards,
SQLisAwe5oMe.
August 10, 2015 at 8:28 am
atulyan.aries (8/10/2015)
I created this in standby/readonly.. but its changed to standby/ singleuser/ readonly..how to do i check who/how was this change done
I do not believe it is tracked, so there would be no way to determine. I suppose it could be put in sql error log.
But the key point is that you can make sure your job does not restore it as standby and then on the next restore it will be fixed. Or you can manually restore the last tlog and fix it immediately.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
August 11, 2015 at 8:45 am
database state changes will be logged in the sql server log, try looking there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply