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 GO 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