Verify SQL Backups With SQL Powershell

Question

Verify SQL Backups With SQL Powershell

Viewing 7 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

GeoffRuble-976616 Old Hand Points: 378 More actions · Answer 1

bnosrati (4/27/2016)
YOUKHANIS.JAMES (4/26/2016)
Hello Geoff, Thank you for the scripts, however when I run the checkbackups.ps1 script nothing is logged and also no data is captured. I am using windows authentication, so i commented out username and password. Can you shed some light on possible issues.
Thanks
I am having the same issue as well. It appears to execute but nothing actually occurs.
Update:
I changed CheckBackups.ps1 line 26 to "Continue" and I am now able to view the errors. It seems that there are some formatting issues with the additional .ps1 files.
For example, invoke-sqlcmd2.ps1 was missing } at the end of the script which was causing it to fail.
Hopefully this information is useful!

Thanks! This is great. I didn't know I could do that. This will help me troubleshoot. In the past I have just had to use trial and error one step at a time, so this will be a big help to me.

GeoffRuble-976616 Old Hand Points: 378 More actions · Answer 2

Jeff Moden (4/26/2016)
YOUKHANIS.JAMES (4/26/2016)
What TSQL statement populates this table?
SELECT [MachineName]
,[AssociatedApp]
,[App_ID]
,[SQLConnectionString]
,[InstanceName]
,[IsActive]
,[Domain]
,[Environment]
,[PDBA]
,[SDBA]
FROM [DBA].[dbo].[ServerList]
Manual INSERTs.

Thanks Jeff!

GeoffRuble-976616 Old Hand Points: 378 More actions · Answer 3

backintheday (4/25/2016)
To echo a previous post, the icons of the scripts and functions at not linked to any source.

The links are now working... they are at the bottom of the article under resources.

bnosrati SSC Rookie Points: 25 More actions · Answer 4

GeoffRuble-976616 (4/27/2016)
backintheday (4/25/2016)
To echo a previous post, the icons of the scripts and functions at not linked to any source.
The links are now working... they are at the bottom of the article under resources.

The files I originally downloaded were inside of the .docx at the end of the post and had formatting issues. I downloaded the ones that were just posted and they seem to be formatted correctly and I was able to get a log file to generate (although nothing wrote to the table). Getting closer..

Willem G SSC Eights! Points: 809 More actions · Answer 5

Ness (4/26/2016)
Nice article although I think "Verify SQL backups" is misleading; there is nothing verifying the backups, just checking that they ran and completed. You would need to restore and integrity check the backups to 'verify'. Perhaps Monitoring SQL Backups would be a better heading.

Monitoring that all your backups run and complete as expected, I believe, is a good start. Verifying them is a next, important step because the proof of the pudding is in the eating..

I run a fully automated restore + dbcc of all our production databases each week, using a PowerShell script I wrote some time ago. In case you're interested, you can find it here:

http://www.sqlservercentral.com/articles/Backup/112463/

bnosrati SSC Rookie Points: 25 More actions · Answer 6

Has anyone managed to get this to run successfully? I am stuck on this and can't seem to get any data written to this variable.

Write-DataTable : Cannot bind argument to parameter 'Data' because it is null.

At T:\VerifyBackups\CheckBackups.ps1:93 char:15

+ -Data $DT_Backups

eliassal Default port Points: 1469 More actions · Answer 7

Geof, nice work, very useful. Can you please share the script that populates the ServerList table or show the contents?
Thanks

Verify SQL Backups With SQL Powershell

Cookies on SQLServerCentral