HI ,
After many trails , finally ended up here.
Could you please help me with working script on how to take Db back of SQL 2012 with a simple Poweshell script ? Working one
Thanks,
Abraham
Technology Tips and News
HI ,
After many trails , finally ended up here.
Could you please help me with working script on how to take Db back of SQL 2012 with a simple Poweshell script ? Working one
Thanks,
Abraham
Check this:
http://www.sswug.org/articlesection/default.aspx?TargetID=44909
http://www.mssqltips.com/sqlservertip/1862/backup-sql-server-databases-with-a-windows-powershell-script/
This one I just tested:
$BackupPath = "F:\Backup"Hi Dave,
Many thanks for your quick turn around.
I have tried your second script and It was working like a charm. But unfortunately its taking back up of all the databases, except tempdb.
But my requirement is to take specific Db as back up eg. TestDb . How can I modify the script to take back up of only 1 Db.
Request you to please help me.
Thanks,
Thanks Dave.
Its working like a charm :)
Thanks,