Regularly Scheduled Backup

I want to set up a scheduled task to do a regular backup and send me the zipped file..

Something like
http://www.sqlteam.com/item.asp?ItemID=11672

Anyone know if this will work, and also, if you have a better script, let me know..
What is the full path I am saving to?

Thanks

 

Forgot to mention, I am running Subtext

My site is http://www.sharpdeveloper.net/

 

Is there a fee to recover my data?



Author, SharpDeveloper.NET - C# articles and more

 

bummer..

so why won't that script work? I had linux hosting and i used to have a daily backup and it would email me a zipped up version by email
dont you provide some sort of script like that?

Sameer


Author, SharpDeveloper.NET - C# articles and more

 

The script won't work because you will not be able to access files on the SQL server from the web server and vice versa.

Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

I find your backup tool lacking...

Use this tool to create a current backup of your SQL 2005 database. The backup file will be placed in the root of your site and named:

SQL2005_368501_default_backup.bak

It doesnt even put the date in there.. so i have to manually rename my backup every time before running this tool....

Author, SharpDeveloper.NET - C# articles and more

 

I am trying this method now - http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups

What folder can I use? What is the folder for user accounts (i.e. my account?) Or is even this method unacceptable?

Author, SharpDeveloper.NET - C# articles and more

 

You cannot perform this kind of backup procedure because your site's folders are not accessible from the SQL server and vice versa.

Your only option is to perform the backup in the control panel.

Aristotle

DiscountASP.NET
www.DiscountASP.NET