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 make your own...

Eirikur Eiriksson (11/29/2016)

---

Mike Scalise (11/29/2016)

---

Hi,

Has anyone been able to successfully use Ola Hallengren's maintenance scripts to only clean up old backups and not take a new backup? I have full...

Ok as long as it makes some sense that it's close but not exact.

Again and again, thanks for your clear explanations.

Mike

Ok how about this?

RecoveryUnitIdFileIdFileSizeStartOffsetFSeqNoStatusParityCreateLSN

0265470464819252142640

02654704646547865651980640

02131645441309491205199064845000006321600279

02144179201441136645200064845000007963800218

02158597121585315845201064845000009766200313

02174325761743912965202064845000011737000392

02192020481918238725203064846000001152400196

02211025922110259205204064847000000976800007

02232652802321285125205064848000000807500257

02255590402553937925206064849000000596200261

02281149442809528325207064850000000404900243

02309329923090677765208064851000000163200013

02340131843400007685209064851000004058400230

02374210563740139525210064852000004186000190

02411566084114350085211064853000004339600100

02452853764525916165212064854000004466800297

02498073604978769925213064857000006689200249

That all makes sense--thanks for explaining that. I think I'm almost there.

I made changes to the database up until the head of the log wrapped around (so at this point...

GilaMonster (9/30/2016)

---

Log backups *and* additional write activity on the DB such that the active VLF wraps around. You can't move VLFs, and you can't ever make the one that's active...

Also, I don't have any open transactions...

Thanks, Lynn.

I ran DBCC LOGINFO and noticed that I have one status of "2" on my last FseqNo, so if the VLF can't be overwritten, it looks like I can't...

John Mitchell-245523 (9/14/2016)

---

Mike

The log backup will only be huge if you haven't backed it up for a long time (or, more accurately, if there has been a lot of changes...

Grant Fritchey (9/29/2016)

---

I'd just do them one after another.

I did set up a Powershell script once that spawned threads to run multiple backups simultaneously. I'll never do that to...

Thanks for the response, RVSC.

See, I don't know exactly when either backup will finish and I want to make the most of the maintenance window. I'm considering creating one job...

I'm sorry, I didn't...

Eirikur,

The step is the "sqlcmd" line that I pasted above. I mean, it passes in T-SQL.

Does that answer your question? Do you know how I would address this?

Thanks,

Mike

Good to know. Thank you!

Thank you!