Regularly Scheduled Backup

[salibhai]

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

[salibhai]

Forgot to mention, I am running Subtext

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

[bruce]

This script probably won't run on our server.


In the mean time, you'll probably have to manually take backup of your database in the control panel and download them.


Note that we also do daily backup of your database.


Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[salibhai]

Is there a fee to recover my data?



Author, SharpDeveloper.NET - C# articles (http://www.sharpdeveloper.net/) and more

[bruce]

Yes. $15 restoration fee.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[salibhai]

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 (http://www.sharpdeveloper.net/) and more

[Aristotle]

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 (http://www.DiscountASP.NET)

[salibhai]

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 (http://www.sharpdeveloper.net/) and more

[salibhai]

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 (http://www.sharpdeveloper.net/) and more

[Aristotle]

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 (http://www.DiscountASP.NET)