Comprehensive data protection for all workloads
Post Reply
staun
Enthusiast
Posts: 58
Liked: 5 times
Joined: Jun 30, 2017 8:48 am
Full Name: Jørgen Staun
Contact:

Restore database - warning

Post by staun »

Our Navision administrator just restored a database to the original by mistake and no warnings about current active database connections to this original database were informed. So he got quite mad at me and with very loud voice - This should not be possible or at least a warning about active connections should be there.

Is it possible to inform the user that there are active database connections before it overwrites the database?
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Restore database - warning

Post by PTide »

Hi,

Did he use 1-Click restore, or some other way? If the former, then there is no check, indeed, just a warning that existing database will be replaced, if present. If the latter, then he should have seen a warning in the restore wizard saying that such database already exists on the target SQL Server.

Thanks
staun
Enthusiast
Posts: 58
Liked: 5 times
Joined: Jun 30, 2017 8:48 am
Full Name: Jørgen Staun
Contact:

Re: Restore database - warning

Post by staun »

The user used the web-interface to restore the database under Items, but forgot to change destination and just restored (I do believe the database will be overwritten warning was there, but he wants a warning that there are active connections, in his mind this is better.?!?).
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Restore database - warning

Post by PTide »

Did I get it right - he basically left this radio-button at "Restore to original location" and hit "Restore" ? I've checked with R&D - the absence of warning is a bug and is scheduled for fixing. Regarding your feature request for checking if there are existing connections - it has been noted.

Thanks
Post Reply

Who is online

Users browsing this forum: Amazon [Bot], Bing [Bot], nikita.kozlenko and 128 guests