create a sql server job , scheduled for daily and in the "steps" include the following script

replace pathname and database names appropriately

DECLARE @datename nvarchar(300)= 'C:\path\to\Backups\your_db_backup_' + CONVERT(varchar(8),GETDATE(),112) + '.bak'

BACKUP DATABASE [YOUR-DATABASE] TO DISK = @datename WITH NOFORMAT, NOINIT, NAME = N'MY_DB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10

On Wed, Feb 5, 2014 at 5:45 PM, gisho <gichuhie@gmail.com> wrote:

i have a script for postgres daily backups

On Wed, Feb 5, 2014 at 5:18 PM, nadhir mohamed <nadhir67@gmail.com> wrote:

am using sql server 2008

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________
skunkworks mailing list
skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke