SQL SERVER DB Restore Powershell

Question

0.00/5 (No votes)

See more:

Recently a task is assigned to me to create a script which restores mutiple databases on SQL Server 2008 R2 server. Powershell was asked to be used..\
The daily backkups are stored at share location from where robocopy is done to one of SQL Server. The data files and log files sit a predefined location on other than C drive.

Would like how to start writing that does the multiple db restore, reads the db name from backup header, which uses with move and replace option of db backup command and preferably also sends an email in event of db restore failure.

One of the script on code project does restore of SQL server db nicely.. how can i loop it?

Thanks in Advance

Posted 15-May-12 0:58am

Fabkhush

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Answer 1 · 2012-05-30T16:54:00

If you already have the Powershell code to restore one database file, you are nearly done. Simply do a Powershell command to list all of the backup files in your folder (wherever they are). Then pipe those file names into your restore script and replace the hard-coded file name in the script with the piped-in value.

If you don't have the backup script or wanted to look at another, here is a fairly good one: http://www.sswug.org/articles/viewarticle.aspx?id=44909[^]

Fabkhush · Answer 2 · 2012-05-30T18:48:00

Solution 2

Thanks.
I have developed the script using for each loop which picks the backup files from a pre defined location, verify backup, read header , does processing for multiple data files and sends an email when restore fails.

Posted 30-May-12 18:48pm