Open powershell console in your desktop, use your server name, instance name, user name and password. You can customize this script, like out put the result into a .txt format by using | out-file “Path\fileName.txt” or use other parameter like “recovery model”
I got help regarding tip from http://www.mssqltips.com/sqlservertip/1784/check-the-last-sql-server-backup-date-using-windows-powershell/
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')| out-null
$srv = new-object ('Microsoft.SqlServer.Management.Smo.Server') "ServerName\InstanceName"
$srv.ConnectionContext.LoginSecure=$True;
## If Using SQL Authentication
##$srv.ConnectionContext.LoginSecure=$False;
##$srv.ConnectionContext.set_Login("UserName");
##$srv.ConnectionContext.set_Password("PassWord")
$srv.Databases | select name, recoverymodel, lastbackupdate, lastlogBackupDate | ft -Wrap –AutoSize
this
I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.
2017-10-30
3,911 reads
Learn how easy the new SQLServer module makes backups of SQL Server databases.
2017-01-12
29,624 reads
Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.
2012-08-14
7,026 reads
If you're starting to learn PowerShell and want to see how you can use it for common DBA tasks, this tip will show you how to create a basic PowerShell script to backup all your user databases.
2011-09-30
3,589 reads