Hey Guys,
Thanks for the reply's. I didn't have to try the script the first 2 options worked for me. It was funny the first time it didn't and then i realized that I had put the period in the .bak file extension just like you said.
I had been waiting until the weekend to get it resolved and knocked it out quickly in several different environments!
Thanks to all!
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field