June 5, 2012 at 11:32 am
This is my first post, hope this is close to the correct place for this topic. We are switching our SAN from IBM SVC using Flashcopy to NetApp (now also owned by IBM) using Cloning to "replicate" databases to multiple servers. The problem occurs when we try to perform a clone when users are running queries against the target database. Our DBA designate has decided to switch the target database into single-user mode then back out immediately which dumps the users out of the database. This works OK but seems like overkill. Does anyone know of a best-practice on how to do this? Our flashcopy implementation takes the database offline. Any Netapp experts out there that can help point us to the most solid solution?
Thank you.
June 5, 2012 at 12:39 pm
Tom McDonald-318966 (6/5/2012)
This is my first post, hope this is close to the correct place for this topic. We are switching our SAN from IBM SVC using Flashcopy to NetApp (now also owned by IBM) using Cloning to "replicate" databases to multiple servers. The problem occurs when we try to perform a clone when users are running queries against the target database. Our DBA designate has decided to switch the target database into single-user mode then back out immediately which dumps the users out of the database. This works OK but seems like overkill. Does anyone know of a best-practice on how to do this? Our flashcopy implementation takes the database offline. Any Netapp experts out there that can help point us to the most solid solution?Thank you.
Instead of switching to single-user then back to multi-user (which opens the possibility that a user can jump in and start a query before the cloning/restore process begins), I would recommend taking the database offline. Once offline, you can move the files, refresh them, etc...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 5, 2012 at 12:56 pm
Thanks for the reply.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply