tag:blogger.com,1999:blog-7656888.post4648888256078061833..comments2023-10-11T04:24:22.301-06:00Comments on Aggregated Intelligence: DPM–Restoring a protected SqlServer database to a different serverRaj Raohttp://www.blogger.com/profile/02773005045522319448noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7656888.post-18708003127915323212013-03-18T22:24:25.575-06:002013-03-18T22:24:25.575-06:00Get the code from: http://pastebin.com/XgphrdB8Get the code from: http://pastebin.com/XgphrdB8Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-9930335444642022252013-03-18T22:20:41.303-06:002013-03-18T22:20:41.303-06:00Ian,
You need to change the values right at the b...Ian,<br /><br />You need to change the values right at the bottom of the entire script. So it would be the part that looks like this: (Also note that doTheRestore is set to true and so it will run the restore. Set it to false to just test it out)<br /><br />RestoreDbFromDPM ` <br /> -dpmServerName "dpmServerName" ` <br /> -sqlProtectionGroupName "ProtectionGroupName" ` <br /> -serverName "DatabaseServerOnWhichTheDatabaseResides" ` <br /> -databaseName "NameOfTheDatabaseToBeRecovered" ` <br /> -restoreToServerName "DatabaseServerToWhichTheRestoreShouldBePerformed" ` <br /> -restorePathMdf "D:\MSSQLData\" ` <br /> -restorePathLog "L:\MSSQLLog\" ` <br /> -dateOfRestoreToUse "2012/01/19" ` <br /> -dpmServerUsedToProtectClient "dpmServerThat ServerName should point to for day to day protection" ` #(not required) <br /> -doTheRestore $true; Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-24278997520613981222013-03-18T08:20:25.991-06:002013-03-18T08:20:25.991-06:00i a completely oblivious when it comes to decipher...i a completely oblivious when it comes to deciphering powershell on my own.<br /><br />i copied this PS to my dpm server. i saw the the flag for $doTheRestore was set to $false. i am taking this as this will run but will not actually restore. So i ran the script to see what put put i get. it returns to the next time. where do i put in my data to get results? <br /><br />I have bee trying to figure this out on my own, but I am at the point where i need to ask for some guidance. please assist if you can.<br /><br />Thank you<br />IanIanhttps://www.blogger.com/profile/00224234728490673244noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-22756458391371200042012-08-09T19:52:22.264-06:002012-08-09T19:52:22.264-06:00Vladimir, serverName would be the server name + in...Vladimir, serverName would be the server name + instance (eg: dbServer\instance).<br /><br />Try it out and let me know if it works.Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-23451094728882548672012-08-09T19:08:19.175-06:002012-08-09T19:08:19.175-06:00Raj,
the params
serverName
restoreToServerName
...Raj,<br /><br />the params<br /><br />serverName <br />restoreToServerName<br /><br />are the name of the servers, not the instances, right?<br /><br />Is there a way to define the name of the Restore instance?<br /><br />Thanks,<br />VladimirAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7656888.post-81138147109195948952012-05-05T07:42:45.616-06:002012-05-05T07:42:45.616-06:00JCTech, I dont know if it will allow to restore fr...JCTech, I dont know if it will allow to restore from tape. But I also dont see why not. You could use it as a starting point and tweak as needed.<br />You certainly can rename the database. But I dont know about different directories. Its been a while since I used the script and forget all its capabilities.Raj Raohttps://www.blogger.com/profile/02773005045522319448noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-91572420162765624772012-05-04T15:09:03.826-06:002012-05-04T15:09:03.826-06:00Raj,
Will your script allow for a restore from ta...Raj,<br /><br />Will your script allow for a restore from tape in DPM and Allow the datbase to be restored to a differnet name?<br /><br />I need to restore PP to PT on the same server from a tape backup.<br />Differnet directories for each database and log file.<br />Thanks<br />BillJCtechhttps://www.blogger.com/profile/09994623720057797528noreply@blogger.comtag:blogger.com,1999:blog-7656888.post-52985788877839711372012-04-19T12:57:54.011-06:002012-04-19T12:57:54.011-06:00Hi Friend,
I´m use script but result error:
My D...Hi Friend,<br /><br />I´m use script but result error:<br /><br />My DPM is PT-BR<br /><br />Analyzing the lines not found errors.<br /><br />Problem my config?<br /><br />É necessário fornecer uma expressão de valor no lado direito do operador '-and'<br />.<br />Em C:\Program Files\Microsoft DPM\DPM\bin\restore-sql.ps1:57 caractere:74<br />+ $_.RepresentedPointInTime -ge $startDate -and <<<<br />< `<br /> + CategoryInfo : ParserError: (:) [], ParseException<br /> + FullyQualifiedErrorId : ExpectedValueExpressionM0nsterMagnethttps://www.blogger.com/profile/08032429051214336195noreply@blogger.com