Hi guys, i created database backup, but now i want it to backup every time when the time is 00:00. Any help will be highly appreciated.
Mongz
-3
Light Poster
Recommended Answers
Jump to PostWhat database are you using? There are different mechanisms to back up MSSQL versus MS Acess for example.
Jump to PostWhy not create a maintenance plan for the SQL Server to do database backups, rebuild indexes, recalculate statistics, trim the transaction log, and do all of the various database maintenance tasks?
As far as scheduling it you will need to write a service that executes the backup command every …
All 5 Replies
sknake
1,622
Senior Poster
Featured Poster
What database are you using? There are different mechanisms to back up MSSQL versus MS Acess for example.
Mongz
-3
Light Poster
I'm using MS SQL 2005 database, i did the code to backup, now i just want to set it to backup at a sertain time
sknake
1,622
Senior Poster
Featured Poster
Why not create a maintenance plan for the SQL Server to do database backups, rebuild indexes, recalculate statistics, trim the transaction log, and do all of the various database maintenance tasks?
As far as scheduling it you will need to write a service that executes the backup command every 24 hours. You could use the task scheduler but I have an application that relies on it extensively and it is very problematic.
shankarkotagiri
0
Newbie Poster
sir i am a c# beginner
now i am doing one project for jewellery mgmt...
i want coding for how to save the data base in entire field ..
shankarkotagiri
0
Newbie Poster
sir i am a c# beginner
now i am doing one project for jewellery mgmt...
i want coding for how to save the data base in entire field ..
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.