Forum Discussion
jcrowing
Apr 11, 2021Copper Contributor
Backup-SqlDatabase backupfile location reference
Hi all, We have two sql servers and I have been running a powershell script on each for the daily full backup. I was looking at perhaps backing them up using a single script from a 3rd server...
farismalaeb
Apr 21, 2021Iron Contributor
Not totally sure, but based on what I read on Microsoft Documentation
https://docs.microsoft.com/en-us/powershell/module/sqlserver/backup-sqldatabase?view=sqlserver-ps
its says
'the backups are stored in the default backup location of the server under the name databasename.bak for full and file backups, or databasename.trn for log backups.'
So it seems its using the server
https://docs.microsoft.com/en-us/powershell/module/sqlserver/backup-sqldatabase?view=sqlserver-ps
its says
'the backups are stored in the default backup location of the server under the name databasename.bak for full and file backups, or databasename.trn for log backups.'
So it seems its using the server