Click here to Skip to main content
14,332,423 members
Rate this:
Please Sign up or sign in to vote.
See more:
hi Every 15 min my database is gone to restore mode and my another database access some table from that database just for select query. b/c of this restoring mode i get error database going to restore mode .. is there any way to avoid this error. i just want to execute select query ...

thanks
gourav
Posted
Comments
   
Not enough information.
—SA
NotPolitcallyCorrect 24-Sep-13 9:42am
   
Since presumably you cannot do anything about the timing, catch the exception and try again at some later point in time. What exactly is the problem?
gourav agrawal 24-Sep-13 10:16am
   
but it gone on restoring mode every 15 min and my query take more than 15 min to execute..
NotPolitcallyCorrect 24-Sep-13 10:36am
   
If you have query that runs for longer than 15 minutes, you need to think about what it is that you are doing and try something else.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Can you grab a copy of the table and use that for your query?
I assume you are using a published table, can you have them change the schedule?
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100