Red Gate forums :: View topic - SQL Response blocks NetApp SnapManager
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

SQL Response blocks NetApp SnapManager

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
normajeanb



Joined: 24 Apr 2009
Posts: 2
Location: Anacortes, WA

PostPosted: Fri Apr 24, 2009 11:57 pm    Post subject: SQL Response blocks NetApp SnapManager Reply with quote

Our production system runs on Blade servers managed by NetApp filers.
Like many NetApp users, SnapManager is the most prominent part of our disaster recovery plan - this tool allows you to configure, schedule and manage SnapShot backups.
One option in the SnapManager backup step is the ability to mount a copy of the newly taken snapshot, and run DBCC checkdb to verify the snapshot backup of the database. After this step completes, SnapManager detaches the database and destroys the temporary LUN it was mounted on.
SnapManager backup jobs (with verification) fail when they run concurrent with SQLResponse because SQLResponse polls and accesses ALL the databases on the server, thereby blocking the detach action of the new database by SnapManager. Once this happens, all subsequent SnapManager backup jobs fail.
If only I could configure SQL Response to only poll certain databases - OR if we could schedule the polling periods for SQLResponse to exclude certain timespans we could work around this. But, I can't seem to locate these configuration options...
It's impractical for me to manually start and stop the service around SnapShot times - and I really lose the value of the product if it's not going most of the time to feed me alerts as they occur.
Do you have any suggestions?
Thanks, Normajean Bowen
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Mon Apr 27, 2009 5:51 pm    Post subject: Reply with quote

Hi,

SQL Response polls the SQL Server every 15 seconds or so, and there isn't any way I know to change that. I would probably solve this problem by scheduling a maintenance interval for the time that you want to verify your snapshots, then create a batch file on the Response repository to stop and start the SQL Response Repository Service during those times by putting the batch file in a Windows Scheduled Task.

Hopefully this would work for you.
Back to top
View user's profile Send private message
normajeanb



Joined: 24 Apr 2009
Posts: 2
Location: Anacortes, WA

PostPosted: Wed Apr 29, 2009 11:29 pm    Post subject: This fixes the Snapshot failure, but SQLResponse stops Reply with quote

Yes, I had thought of doing that too - so I went ahead and created the jobs, scheduling them around the snapshot database cloning time BUT once SQLResponse gets a force disconnect from the stopped service, it doesn't try to reconnect by itself...I have to remember to manually go back in to the app and re-establish the connection in order to get back online for my raised alerts.
I don't think this is going to be a workable "workaround" for me...
Normajean
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Mon May 04, 2009 6:40 pm    Post subject: Reply with quote

Hi

Following our telephone conversation earlier today, I have added your Support Call details to an existing Feature Request whose reference is SSR-1377 "Ability to configure the amount of e-mails that you get for certain alerts". Following our discussion regarding the E-Mail notifications.

I created a new Feature Request whose reference is SSR-1602 "To be able to deselect databases on a SQL Instance from being monitored"

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
msright1981



Joined: 10 Jul 2010
Posts: 1

PostPosted: Sat Jul 10, 2010 7:18 pm    Post subject: IBM Tivoli Storage FlashCopy Manager Reply with quote

I have seen many companies depending on NetApp SnapManager to backup their SQL using snapshot, though we have IBM DS8000 & would like to do what others are doing with NetApp SnapManager for SQL. The best I was able to get to was IBM Tivoli Storage FlashCopy Manager Tutorial though I am still curious how stable is this IBM Tivoli Storage FlashCopy Manager & how much of the NetApp SnapManager functionality it can offer. Is it worth it?

Thanks for your help in advance,
_________________
Enjoy,
Julie
http://www.Linux2Aix.com
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group