September 29, 2003 at 1:51 pm
Hi Folks,
I have a silly question. I'm using logshipping to keep my servers concurrent, but I'm having a problem with users getting a message that the database can not be opened during a restore. Is there anyway to have SQLserver que the request for the few milliseconds it takes the restore to occur? Its not as big an issue for our inhouse VB applications as it is for our web apps.
Thanks in advance!
Patrick
Hi Joe.. thought you might like this
September 29, 2003 at 2:47 pm
no way I know of. Better to write some check in there, perhaps add a table to some other database and mark this before a restore and unmark it after. Let the apps check and give the user a msg if they see a restore.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 30, 2003 at 8:25 am
Steve,
Thanks! I've done that in the past for other projects...don't know why I didn't think of it for this.
Hi Joe.. thought you might like this
Hi Joe.. thought you might like this
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply