hi,
i am using sm sql express 2008 and this does not have the backup feature. so i have to create a application to back up the database everyday automatically, does anybody know a way to do it,please reply
thank you.
judithSampathwa -2 Posting Pro in Training
judithSampathwa -2 Posting Pro in Training
i have the database in ser-3 and i want to create a back up in ser-2 but i am running the application from another pc which is desk-66
omar isaid 0 Light Poster
Dear the jobs are defined in SQL Server 2008 by SQL Server agent , which is not included in the Sql Server 2008 express edition
what you think of third party product see the below link
http://www.valesoftware.com/products-express-agent.php
omar isaid 0 Light Poster
If you want to schedule your backup jobs, you have to write a T-SQL script and then use the Windows Task Schedule to call SQLCmd to run the script on what every schedule you're interested in:
sqlcmd -i C:\SqlJobs\backup.sql -o C:\Logs\output.txt
see the below link
http://www.mssqltips.com/sqlservertip/1486/automate-sql-server-express-backups-and-deletion-of-older-backup-files/
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.