Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
Thanks for the answers. Glad you like the proposed buttons.
That is where you are wrong:
I say this because it would be invalid to specify the name of a database that
already exists on the server with any other file paths because it wouldn’t
restore anyway. – Perhaps that’s where I’m wrong? I’ve
not tested that… can you actually restore over the same name as an
existing mounted database, but put the files somewhere else? I don’t think
you can.
And the answer to your question is – yes, you can restore db over the same
name as an existing mounted db, but with new mdf, ldf files location.
Here are some proof pics:
But, please note there is an issues in Toad scripting that Recovery State option
scripted as NORECOVERY even if was set to ‘Restore with recovery’
that definitely is wrong and was already fixed on the next version.
