How to take database backup automatically after 1 hour in .NET

Harsh Gour

I want to take my database backup every 1 hour in .net is there any way to take a backup of the database in the root folder

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs2y ago
The Windows Task Scheduler can be used to execute a program every hour.

Vishal Yelve2y ago

Hi Harsh,

you can create a programe to execute below sql script to take backup of your databse every 1hour.

declare @backuppath as nvarchar(max)
set @backuppath  = N'C:\WorkingProjects\Practice\DataBase\Employee\EmployeeDB_'
+ CONVERT(nvarchar,YEAR(getdate()))
+ CONVERT(nvarchar,Month(getdate())) +
+ CONVERT(nvarchar,DAY(getdate())) + '.bak'
Backup Database [EmployeeDB] to DISK = @backuppath WITH NOFORMAT, NOINIT, NAME=N'EmployeeDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO