April 20, 2015 at 3:20 pm
Hi guys i am in need of a power shell script that can scan our network share for back up files of databases that have been dropped for deletion. Any assistance will be appreciated.Thank you
April 21, 2015 at 2:57 pm
Just to clarify, are you saying that you want to look for recently deleted backup files?
Edit:
Oh, I think I see what you mean, you're looking for a script that will use recently dropped databases as a reference, and then scan the network to look for backup files for that now deleted database.
Is that right?
If so, it's kind of dangerous. However, as long as the database name or some single reference is in the backup file, it can be done. The problem is, it's probably going to take a really long time to complete.
April 21, 2015 at 3:57 pm
JoshDBGuy (4/21/2015)
Just to clarify, are you saying that you want to look for recently deleted backup files?Edit:
Oh, I think I see what you mean, you're looking for a script that will use recently dropped databases as a reference, and then scan the network to look for backup files for that now deleted database.
Is that right?
If so, it's kind of dangerous. However, as long as the database name or some single reference is in the backup file, it can be done. The problem is, it's probably going to take a really long time to complete.
That is correct....the script will be ran on a development server
April 21, 2015 at 4:04 pm
How many different locations? Are the files in a standard format? Do they all ind with .bak or .sqb? Are the locations share mapped or drive mapped?
It will be a lot easier with a list of servers to look through if the share's aren't mapped.
April 22, 2015 at 9:20 am
JoshDBGuy (4/21/2015)
How many different locations? Are the files in a standard format? Do they all ind with .bak or .sqb? Are the locations share mapped or drive mapped?It will be a lot easier with a list of servers to look through if the share's aren't mapped.
Two locations, Files have the .bak extension and the locations are drive mapped
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply