Thanks for weighing in, Jeff. So if I'm understanding you correctly, you end up with an exact clone of the box, and the ETL tools would sit on a separate...

Ah, so much better! I must have toggled that setting after installing SSMS 2016 a while ago and then forgot about it. Thanks for the help, guys!

Mike

Thanks, guys.

John,

The database does not already exist on the target server and I don't have Instant File Initialization enabled.

Ken,

Thanks for the VLF...

Yes, for the most part we do.

Thanks, Chris. Fortunately, only a few of those applied in this scenario. I was able to script most of what I needed. Thanks again.

Mike

Thanks, Perry. I did a combination of scripting the sys.configurations table and scripting the logins. I think that should do the trick!

Mike

pietlinden,

This is incredibly...

TheSQLGuru (12/2/2016)

---

Still sick and jet lagged, but what you said makes sense to me. You simply must make sure you have the FULL backup that is the basis for any...

HOWEVER!!!! If you truly want to be able to restore a full 2 weeks back you actually need to keep TWENTY days of FULL backups because as soon as you...

TheSQLGuru (12/1/2016)

---

Mike Scalise (12/1/2016)

---

Ohh. My apologies. I thought you were making a general recommendation for running Ola's scripts.

Yes, I could see how setting that flag in the command might achieve...

Ohh. My apologies. I thought you were making a general recommendation for running Ola's scripts.

Yes, I could see how setting that flag in the command might achieve the results I'm...

TheSQLGuru (11/30/2016)

---

Ahh, well, that's what happens when you post after days of being sick and starting an international trip. :hehe:

Taking a closer review (albeit after being sick for more days...

TheSQLGuru (11/29/2016)

---

Mike Scalise (11/29/2016)

---

TheSQLGuru (11/29/2016)

---

Ola's code is completely open for you to modify to suit if you need to. If the options don't allow you to do NO backups just...