software:microsoft:sqlserver
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
software:microsoft:sqlserver [2018/06/21 20:34] – [How do I run a ps1 elevated as a scheduled job] superwizard | software:microsoft:sqlserver [2018/09/13 20:28] (current) – superwizard | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== I can't connect to my servers SQL database via an IP Address ====== | ||
+ | |||
+ | From: https:// | ||
+ | |||
+ | < | ||
+ | open SQL Server Configuration Manager; | ||
+ | switch to the SQL Server Network Configuration | Protocols for SQLEXPRESS; | ||
+ | double-click the TCP/IP protocol; | ||
+ | select the Yes value in the Enabled field; | ||
+ | switch to the IP Addresses tab; | ||
+ | </ | ||
+ | |||
+ | ====== Backup with powershell ====== | ||
+ | < | ||
+ | ps1 script | ||
+ | Backup-SqlDatabase -ServerInstance Machine096\SSERVICES -Database IServices -BackupAction Database -BackupFile " | ||
+ | Exit | ||
+ | |||
+ | |||
+ | Cmd file | ||
+ | powershell.exe -executionpolicy bypass | ||
+ | -file " | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | From: https:// | ||
+ | |||
+ | < | ||
+ | I am not familiar with Python, but for your current requirement (i.e. backup). I'd strongly | ||
+ | recommend you to use PowerShell for two reasons: | ||
+ | |||
+ | MS in its SQLPS module (since SQL Server 2012), has a native cmdlet called | ||
+ | |||
+ | Backup-SQLDatabase | ||
+ | |||
+ | You may run this cmdlet on one central server to do the backup against multiple sql instances | ||
+ | at once because this Backup-SQLDatabase can accept multiple sql instances, like the following example | ||
+ | |||
+ | Backup-SQLDatabase -Database master -Server " | ||
+ | This 2nd point may help you to centralize all those backup scripts to one administration | ||
+ | server (dedicated for DBA use) instead of sparsely stored on each sql server instance. | ||
+ | |||
+ | Also with MS providing Backup-SQLDatabase, | ||
+ | all future new features. (For example, using this cmdlet to support Azure SQL Database etc.) | ||
+ | </ | ||
+ | |||
====== restoring SQL backup files to new filepaths ====== | ====== restoring SQL backup files to new filepaths ====== | ||
software/microsoft/sqlserver.1529613272.txt.gz · Last modified: 2018/06/21 20:34 by superwizard