Skip to content

Instantly share code, notes, and snippets.

@Boggin

Boggin/Backup-Database.ps1

Created September 13, 2018 11:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Boggin/bb1ba90e986f9bb152c3dd4a4d228137 to your computer and use it in GitHub Desktop.
Save Boggin/bb1ba90e986f9bb152c3dd4a4d228137 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Backup-Database.ps1
Import-Module SqlServer
$srv = New-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = $srv.Databases.Item("IntermediaryManagement.DB")
$scrp = New-Object Microsoft.SqlServer.Management.Smo.Scripter($srv)
$scrp.Options.ScriptData = $TRUE
$scrp.Options.ScriptSchema = $FALSE
$tbl = $db.tables | Where-Object { $_.IsSystemObject -eq $FALSE }
$scrp.EnumScript(@($tbl)) | %{ Add-Content temp.sql $_ }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment