March 21, 2014 at 10:41 am
Scenario: We only name our DB "TEST" weather it is DEV, QA or PROD for all of our clients. That's why we have separate instance for all the databases so the database is not "TEST_DEV" or "TEST_QA", they are just "Test". It also helps me refresh the database because of the naming convention.
My question is that if I install 1 instance for DEV and QA, I 'd then have to name them "TEST_DEV" and "TEST_QA" which would make database refreshing from a DB called "TEST" more difficult.
Can someone let me know if I'm mistaken on the above assumptions.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 21, 2014 at 12:51 pm
Installing a different instance shouldn't matter as it'd be SERVER\DEV and SERVER\QA
You could keep the same database names as well, and wouldn't need to change the database name during restores
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 21, 2014 at 1:08 pm
I just want to make sure that I understand you correctly.
I can have 1 instance for 2 databases and if I need to refresh it from the production "TEST" to "TEST_DEV or TEST_QA", it won't be problematic.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 21, 2014 at 1:19 pm
Correct. You can change the names of the database and files during the restore process
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 22, 2014 at 7:59 am
Thank you Sir!;-)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply