automatic daily backups for sql db
Look into running a cron job for automated scheduled backup of the files On Wed, Feb 5, 2014 at 3:25 PM, nadhir mohamed <nadhir67@gmail.com> wrote:
hi? any idea how i can do the above!
_______________________________________________ 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
Which version of sql are you running? Regards, Peter Mugoh Sent from my BlackBerry® -----Original Message----- From: nadhir mohamed <nadhir67@gmail.com> Sender: skunkworks-bounces@lists.my.co.ke Date: Wed, 5 Feb 2014 15:25:10 To: Skunkworks Mailing List<Skunkworks@lists.my.co.ke> Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: [Skunkworks] automatic daily backups for sql db _______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://orion.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
Cron job for a mysqldump > \fileloc\datestampedfile.sql On 5 Feb 2014 15:25, "nadhir mohamed" <nadhir67@gmail.com> wrote:
hi? any idea how i can do the above!
_______________________________________________ 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
am using sql server 2008
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
you can use the maintenance plans under management to schedule your tasks - including automatic daily backups- On 5 February 2014 17:45, 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
-- Be the change you want to see in the world.
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
Hi, Windows has a scheduler. You need to use it to run the backup script with the desired frequency. Try this: https://support.microsoft.com/kb/2019698 Kind regards, Bernard 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
See the link below : http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-back... Peter Mugoh Sent from my BlackBerry® -----Original Message----- From: nadhir mohamed <nadhir67@gmail.com> Sender: skunkworks-bounces@lists.my.co.ke Date: Wed, 5 Feb 2014 17:18:24 To: Skunkworks Mailing List<skunkworks@lists.my.co.ke> Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] automatic daily backups for sql db _______________________________________________ skunkworks mailing list skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://orion.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
This works for me http://sqlbackupandftp.com/ On 5 February 2014 18:05, Peter Mugoh <pkmugoh@gmail.com> wrote:
See the link below :
http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-back...
Peter Mugoh
Sent from my BlackBerry®
-----Original Message----- From: nadhir mohamed <nadhir67@gmail.com> Sender: skunkworks-bounces@lists.my.co.ke Date: Wed, 5 Feb 2014 17:18:24 To: Skunkworks Mailing List<skunkworks@lists.my.co.ke> Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] automatic daily backups for sql db
_______________________________________________ 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
use Maintenance Jobs and SQL Server Agent ... On Wed, Feb 5, 2014 at 7:13 PM, John K. <kamau.john@gmail.com> wrote:
This works for me
On 5 February 2014 18:05, Peter Mugoh <pkmugoh@gmail.com> wrote:
See the link below :
http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-back...
Peter Mugoh
Sent from my BlackBerry®
-----Original Message----- From: nadhir mohamed <nadhir67@gmail.com> Sender: skunkworks-bounces@lists.my.co.ke Date: Wed, 5 Feb 2014 17:18:24 To: Skunkworks Mailing List<skunkworks@lists.my.co.ke> Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] automatic daily backups for sql db
_______________________________________________ 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
_______________________________________________ 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
thank you all for your suggestions which came in handy! i implemented the idea of one john kamau, which to me involved the least effort!
participants (10)
-
Agosta Liko -
Allan O. -
Bernard Wanyama -
gisho -
John K. -
Kiti Chigiri -
nadhir mohamed -
Peter Muchemi -
Peter Mugoh -
Tony Waichungo