Reputation
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Supporter
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Mar
4
comment TSQL command to delete backup files older than N hours
And this information is right. It confuses everyone, including me, but now I know it won't overwrite the old backups by itself. This option only allows you to overwrite backups that had expired and error out when you try to overwrite a backup that did not expired yet.
Mar
4
comment TSQL command to delete backup files older than N hours
No, the backup will not ovewrite the existing expired backups. It will append the same way, but prevent from restore the expired ones.
Aug
29
comment Management Studio System.OutOfMemoryException
Are you tring to run a long batch of queries? This also happens when you try to run a big SQL file inside SSMS. Selecting part of the file to run or dividing this long file into separate smaller ones can help in this cases.
Jun
9
awarded  Supporter
Nov
14
awarded  Autobiographer