This is my script. I am trying to restore a sql backup over to another database. When i run this. This tried to override the original database even though i am specifying a new database. See my script below:
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null
$File =gci c:\sqlbackups -include cstest.bak -Recurse
copy-Item $file -Destination C:\Webpub\Crockford
Import-Module SQLPS -DisableNameChecking
Restore-SqlDatabase -Serverinstance "SUPPORTPC14\SQLEXPRESS" -database "CSTest" -BackupFile $CrockfordFile -ReplaceDatabase
Yeah, SMO can be a bit tricky. I'll tell you – you may get a better answer someplace like StackOverflow, because you're really using SMO, which is part of .NET, and not really using "native" PowerShell stuff, which is what we specialize in here.
I do know that there's a complex override needed in order to keep a backup from going back to its original location, but I've never needed to code for that myself.
You must be logged in to reply to this topic.