Viewing 5 posts - 16 through 20 (of 20 total)
PowerShell uses the .NET format for date and time. You can look at https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings to see how t to use the build in standard formats. If you need something more...
February 22, 2019 at 9:35 am
Does the $dt variable have the servers in it? Are you getting an error? For the $sql, you are not using the $NewObj variable to enter the values from the...
February 22, 2019 at 9:31 am
I personally like using the dbatools PowerShell module - https://dbatools.io/. There are several commands, like Export-DBALogin, that can assist with scripting out logins or users and their permissions.
February 21, 2019 at 9:55 am
It looks like your function can return nothing. You will want to add code to account for that. For the the Try...Catch statement, you will want to add the parameter...
February 20, 2019 at 7:34 am
You may want to run the following:
SELECT name, log_reuse_wait, log_reuse_wait_desc FROM sys.databases
This will show you if the log is waiting on anything. Check out...
February 7, 2019 at 8:07 am
Viewing 5 posts - 16 through 20 (of 20 total)