Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question about listing Backupnames of MSSQL-Backups #7

Open
gihafopow opened this issue Jul 28, 2023 · 0 comments
Open

Question about listing Backupnames of MSSQL-Backups #7

gihafopow opened this issue Jul 28, 2023 · 0 comments

Comments

@gihafopow
Copy link

Hi bottkars,

i tryed your Demo "Asset Restore MSSQL Powershell" but i don't have figured out how to list the Backupnames too.

For monitoring purposes my interesst is only to see what backups exists for a instance for every database.

If i use the program msagentadmin.exe administration --list --appID "mssql" ...
i see for every DB of an instance this columns:
currenttime; Client = xxxx; date and time = xxxx; size = xxxx; name= BackupName that i had specified when i made the backup

This for every DB and for every backup of an instance in the time-range i specified in the filter.

for example:

2023-07-28T14:00:20.894Z Client = Server1, date and time = 28.07.2023 14:15:13 (1690546513), size = 8513440, name = TLOG_2023-07-28_02-15_Server1:master.

But with Get-PPDMassetcopies i was not able to see the BackupName (TLOG_2023-07-28_02-15_Server1:master.), that the Backup has.

How can i list all Backupnames of all existing backups of an instance?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant