May 17, 2014 at 3:06 pm
I can backup sql server this way http://support.microsoft.com/kb/2019698, and with the tool sql backup master. I can easily backup files with .bak extension, but I need to auto backup files with window task scheduler so they are zipped, and look something like this (name of database)_(day)_(date)_(year).zip. Do somebody knows the solution?
May 18, 2014 at 10:22 pm
Hi,
You can try this approach:
Create a powershell script that zip the backup file. Here's the instruction.
Then create a widows task schedule with the powershell script. Here's the instruction. Or create a sql agent job on a SQL Server instance. Here's the instruction.
--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.
May 20, 2014 at 6:01 am
Thank you for your post, my friend. I have found the solution. First follow this instructions for .bak backup http://support.microsoft.com/kb/2019698, then for zipping the .bak files http://www.organicweb.com.au/15111/general-technology/windows8-batch-backup/#comment-1665, and at the end if you want to modify datetime http://stackoverflow.com/questions/1192476/windows-batch-script-format-date-and-time.
Beside the links above, this one is okey to http://www.bahramov.com/2009/03/19/creating-a-compressed-sql-server-database-backup/.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply