Reputation
606
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 14
Newest
 Yearling
Impact
~21k people reached

  • 0 posts edited
  • 2 helpful flags
  • 53 votes cast
May
21
awarded  Yearling
May
9
awarded  Notable Question
Feb
16
awarded  Popular Question
Feb
16
comment sql agent job: How to set max run time for powershell step
@Kin Thanks! OK... not a good practice... so what is the right practice to automatically manage a hung job?
Feb
16
asked sql agent job: How to set max run time for powershell step
Feb
14
comment How to see entire job step output?
If we send to flat file, does that get overwritten every job, or appended to? Yes, sending output to history is cumbersome to read, but it has the advantage of being easy to turn on and off. (and it gets cleaned up by history cleanup...)
Feb
14
accepted How to see entire job step output?
Feb
13
asked How to see entire job step output?
Feb
11
revised Sql server 2014: backup log to 2 destinations
added 118 characters in body
Feb
11
accepted Sql server 2014: backup log to 2 destinations
Feb
11
comment On Prem SQL Server: Log shipping via Azure Blob Storage: Possible?
@PaulWhite fyi, MS seems to have pulled that post... "This topic is no longer available" I saw it when you first posted it, even read it. (even printed it! But tossed the hard copy.) but now it is gone.
Feb
11
answered SQL Server Log Shipping: Copy copies 0 files
Feb
11
comment SQL Server Log Shipping: Copy copies 0 files
@Shanky this was configed via tsql.
Feb
11
asked SQL Server Log Shipping: Copy copies 0 files
Feb
9
comment SQL Server log shipping: How to give SQL Agent the needed rights to remote share?
@shanky this post is a request for a pointer to steps or docs that explain this aspect. The docs i have found so far do not address this aspect head on.
Feb
9
comment SQL Server log shipping: How to give SQL Agent the needed rights to remote share?
@Shanky Fair call, but it is the same issue in either direction.... backup log across unc path to remote, or copy from unc to local.... either way, same rights issues apply I believe. In ex above, we are trying to back up log directly to secondary.
Feb
9
asked SQL Server log shipping: How to give SQL Agent the needed rights to remote share?
Feb
6
comment Sql server 2014: backup log to 2 destinations
@KrisGruttemeyer I agree. The SQL Server community is amazing. Maybe it is out there, but I have beat a lot of bushes, and have not found a widely used community source replacement for the built in log shipping. I was hoping to find a powershell or similar replacement to the exe used by native log shipping. Such a kit would let me extend the mechanism for moving the files.
Feb
6
comment Sql server 2014: backup log to 2 destinations
Thanks! How do you use a file system task to push to azure blob storage or S3?
Feb
6
comment Sql server 2014: backup log to 2 destinations
@Zane It is not 10 days to write a powershell script. It is multi days of development to re-create the log shipping mechanism, with history tracking monitor-ability, healing for all the little issues that happen moving files to S3 or azure, etc. E.g. to make a system that is robust and useful in a production environment.