MENU
When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore
Location as New Location?
37 comments · newest first
TH
Theola
10 months ago
A is crucial for point in time restores, can't overlook that!
RE
Rebecka
10 months ago
Wait, why would anyone choose a new location? Sounds risky!
HO
Howard
10 months ago
Option B makes sense for following best practices.
BR
Brianne
10 months ago
I think D is a valid reason too, speed matters!
MO
Mona
10 months ago
I disagree, keeping the original schema is important, so C is better.
MI
Michel
11 months ago
I vaguely remember that restoring quickly is crucial, so option D might be the right choice if the original files are on the same disk.
TH
Theodora
11 months ago
I practiced a similar question, and I feel like keeping the original schema in place is important, but I’m not sure if that’s the right reason for choosing a new location.
OS
Osvaldo
11 months ago
I think option B sounds familiar, especially with Nutanix best practices, but I can't recall the exact details.
LA
Lajuana
11 months ago
I remember something about restoring to a new location being useful for testing purposes, but I'm not sure which option fits that best.
GR
Graciela
11 months ago
Alright, I think I've got it. The administrator would choose a new location if they want to get the database restored as quickly as possible, since the files are on a disk with other databases. That's option D, right?
LE
Lettie
12 months ago
I'm a bit confused on this one. I know the administrator might want to keep the original schema, but I'm not sure if that's a valid reason to choose a new location. I'll have to think about this a bit more.
SA
Samira
12 months ago
Ah, I think I've got it. The administrator would choose a new location if they want to apply Nutanix best practices, as option B suggests. That makes sense to me.
CH
Chu
1 year ago
Okay, let's see. I'm pretty sure the log files are needed for a point-in-time restore, so that's not the right answer. I'm leaning towards either B or D, but I'm not 100% sure.
KA
Kaycee
1 year ago
Hmm, this is an interesting one. I think the key here is understanding the different reasons an administrator might choose to restore to a new location. Let me think this through...
DE
Desiree
2 years ago
Option B, all the way! Nutanix best practices? Sign me up! Although, I do wonder if Era can also do my laundry...
SH
Sharen
1 year ago
B) The administrator wants to restore to a new location and have Era apply Nutanix best practices. That would be so convenient!
MA
Marvel
1 year ago
D) The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
TA
Tamar
1 year ago
C) The administrator wants to keep the original schema in place.
MI
Mila
1 year ago
B) The administrator wants to restore to a new location and have Era apply Nutanix best practices.
LY
Lynelle
1 year ago
User2: User3, haha, that would be convenient though!
JE
Jerry
1 year ago
User3: User1, I think Era can only help with database tasks, not laundry.
CA
Carri
1 year ago
User2: User1, I agree! It's always good to follow best practices.
ER
Erick
1 year ago
User1: Option B, all the way! Nutanix best practices? Sign me up!
DO
Dong
2 years ago
Or maybe they need to separate the database files for better performance.
CO
Cora
2 years ago
Option A, of course! Those log files are essential for a point-in-time restore. What kind of SQL Server admin would skip that?
NU
Nu
2 years ago
Option C, definitely. Gotta keep that original schema in place, no matter what!
TE
Tesha
2 years ago
That's true, but maybe they want to keep the original schema intact.
TA
Tanesha
2 years ago
I'd go with Option D. Getting the database restored as quickly as possible is the top priority, right?
AB
Abraham
1 year ago
Definitely, minimizing downtime is key in these situations.
GL
Glory
1 year ago
I agree, time is crucial when it comes to database restoration.
CA
Cary
1 year ago
Option D sounds like the best choice. Speed is important when restoring a database.
LE
Lennie
2 years ago
But wouldn't it be faster to restore to the original location?
TE
Tesha
2 years ago
I think the administrator might choose New Location to follow best practices.
VI
Virgilio
2 years ago
Option B seems like the way to go. Restoring to a new location and letting Era apply Nutanix best practices sounds like a great idea!
EL
Elsa
1 year ago
D) The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
AR
Aretha
1 year ago
C) The administrator wants to keep the original schema in place.
VI
Vincent
2 years ago
B) The administrator wants to restore to a new location and have Era apply Nutanix best practices.