Archive
Posts Tagged ‘#Powershell’
PowerShell script to backup a database and restore on other server.
December 16, 2012
18 comments
Many a times as a DBA when we need to refresh our QA or Dev environment with Production environment, we need to have a full backup of Production database and then manually we need to restore them in other environments. The following is a simple power shell script to just take a full backup with copy only option and then restore it on other server. Read more…
Categories: Powershell
#Powershell, powershell for
Powershell – Powershell Script to backup all user DBs in SQL Server
May 23, 2012
12 comments
Powershell is Microsoft’s task automation framework.
The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…
Categories: Denali, Powershell, SQL Server, SQL Server 2008 R2
#Powershell, Denali, powershell for