question

MickyMd avatar image
MickyMd asked

SQL backup info from PowerShell

Morning , Hope this is a quick one to answer. I have a PowerShell script that pushes out backup info from SQL into Excel spreadsheet. Do I need to have Excel installed on the SQL server in order to capture it? Even if location for file to be saved is on another server? Cheers (PowerShell newbie)
powershell
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This site functions according to votes. For all helpful answers below, show this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
If you are using -ComObject Excel.Application Then I would think that Office/Excel needs to be installed?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
Instead of using Excel, just output to comma delimited CSV file. You can then open that in Excel just fine. No pretty formatting though. Otherwise, @Kev has it, you need to install Excel.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.