October 18, 2005 at 9:20 am
(Visual 6.0 C/C++)Lets say you have a piece of code that does database updates to a primary server at a remote site and these updates take about 2 to 3 seconds to complete. This application is designed to collect, parse, and save data in a do while true loop that runs forever. Now, lets say that all works great until...
at a specified time during the week, the remote server enters maintenance mode where the tables are backed upa nd all the tables are optimized and shrunk (standard maintenance).
During this time, the application crashes with run time error. If I turn off the server optimization (database tuning), then all is well and the app runs fluidly.
Is there a way to detect and avoid this condition, i.e. detecting if the database is in or enterring into maintenance mode? I am stuck on the proper method of dealing with this one.
October 18, 2005 at 9:29 am
Tripple post due to memory exception.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=229771
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply