Powershell : Backup-SqlDatabase -ExpirationDate

Question

I try to use the snap-in Backup-SqlDatabase with an expirationDate, and I get an error : invalid value for the parameter EXPIREDATE. Can someone tell me how to format this parameter ?

Here's my code :

$expirationDate = Get-Date
$expirationDate = $expirationDate.AddDays($expirationDelayInDays)

Backup-SqlDatabase -ServerInstance $serverInstance -Database $database -ConnectionTimeout 0 -BackupFile $outputFile -ExpirationDate $expirationDate

According to the documentation expirationdate should be of type DateTime. However, it seems you're not updating the $expirationDate on your second line. Could you try: $expirationdate = $expirationdate.adddays($expirationDelayInDays) — jon Z
– jon Z, Commented Jun 17, 2013 at 10:16
You're right, I changed the code... not better. $expirationDate is DateTime I believe. — boblemar
– boblemar, Commented Jun 17, 2013 at 10:50
Strange as the code works for me, what value are you using for the variable $expirationDelayInDays? It may be that rather than a formatting issue, the value you are passing is indeed invalid as a datetime is definitely the only type this parameter will accept. — steoleary
– steoleary, Commented Jun 17, 2013 at 12:57
I use 7 for $expirationDelayInDays. To me $expirationDate is a datetime, am I wrong ? — boblemar
– boblemar, Commented Jun 17, 2013 at 14:40
OK. It seems that $expirationdate should not be of DateTime type ! ... but a string that can be converted into a datetime. When using $expidationdate = "2013-09-01" it works...but I believe there is a bug in the convesion so that 09 and 01 are inverted. — boblemar
– boblemar, Commented Jun 20, 2013 at 9:44

lauxjpn · Accepted Answer · 2020-12-06 17:40:53Z

1

EXPIREDATE only handles dates. It does not handle time components. Therefore, you need to specify a DateTime with an empty time component (using the DateTime.Date property):

$expirationDate = (Get-Date).AddDays($expirationDelayInDays).Date
Backup-SqlDatabase -ServerInstance $instance -Database $database -ExpirationDate $expirationDate

answered Dec 6, 2020 at 17:40

lauxjpn

5,4092 gold badges25 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell : Backup-SqlDatabase -ExpirationDate

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related