RE: Taking backup with option "Disk = nul"

SSC Guru

Points: 1003863

June 20, 2018 at 7:13 pm

#1994756

pdanes - Wednesday, June 20, 2018 4:29 PM
Would that have the same effect as what I'm doing? I have studied backup manuals and online tutorials until I'm blue in the face, but I'm still a little vague on some details. I have a working setup, and I'm a little reluctant to tinker too much, because I'm always short on time, and a little nervous about breaking a working system with live data. This may not be the most efficient way to do it all, but it works, and (I think, anyway) I understand it. I happened to run across this thread while looking for something else, so I put in my comment about how I use the nul device, since that is what the thread addresses.

I agree and I mean no irony in the following... sometimes it's best to not mess with Mother Nature, especially at the suggestion of a relative stranger on the forum that doesn't know squat about your actual data, etc ( might not be a stranger to you but I know nothing of your systems). If what you have is working and it's not causing you pain nor taking huge amounts of time to keep doing what you're doing, then making a change would require a whole lot that might not make such a change worth it. No matter what the change is, there is always some risk.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)