Question : Trying to connect database with an encrypted connection, tried below sql queries: sqlcmd -N -E -S tcp:SQLSERVER,1234 -U […]
Tag: dbatools
Passing in multiple instances into the dbatools command GET-DBADBFILE
Question : I am attempting to gather all of the dbfile information on all of our sql instances in one […]
Test-DbaDiskAlignment Not Working
Question : PS H:> Test-DbaDiskAlignment -ComputerName Test_Server WARNING: [Test-DbaDiskAlignment][22:09:54] Can’t connect to Test_Server WARNING: [Test-DbaDiskAlignment][22:09:54] CIM query to Test_Server failed. […]
Should dbatools be installed on all SQL Servers
Question : I’m looking to leverage dbatools powershell module for our SQL Server management needs. The install process does not […]
Sync Server Objects when having two or more Availability Groups
Question : Lets imagine that i have two servers/nodes with TWO availability groups Group01 and Group02. I will need to […]
Can Set-DbaAgReplica filter any SqlInstances out
Question : I have been working with an Availability Group with an extra asyncronous secondary, that is always set to […]
How to find port using Get-DbaTcpPort
Question : How to find whether the port used by SQL Server is static or dynamic using Get-DbaTcpPort dbatools command? […]
dbatools start-dbamigration running very slowly
Question : I am trying to use the powershell module dbatools to migrate one SQL Server instance to a new […]
How can I add timestamp into my table when I use Write-DbaDbTableData?
Question : I am trying to use one table to store the SQL server disk space checking data by dbatools: […]
DBATools offline install – export-dbainstance was not found
Question : I followed the instruction at https://dbatools.io/offline/: download zip & unzip run $env:PSModulePath to find all the paths. copy […]
- 1
- 2