Backup policy - suggestions welcome in ASP.NET

Control Panel Forum Hosting Help ASP.NET 4 & SQL 2008 R2 Hosting Resources Notice

Total members: 210367
Average new registrations per day (in last 7 days): 16

New Registration: Open

Register Now

Home » Questions & Answers » Backup policy - suggestions welcome

Backup policy - suggestions welcome

11/5/2005

Author: Tony JOhn (Webmaster)
webmaster - AspSpider.NET
http://aspspider.org/manjaly

My Beta site

Here is a great chance to let us know how you want it!

We are working on various options to allow our members to backup the database periodically, without active involvements of support team and without compromising security of other members data. Please post your suggestions here.

You may also post scripts and code snippets along with your suggestions. We will evaluate all options and finally decide on what is best for everyone.

When you post your suggestions, consider both MS Access and SQL Server databases.

Answers .............

Author: Sumit

MIT,Manipal

Posted Date: 11/7/2005

i guess ftp wil be the easy and best choice to copy or paste not even just the data but pages too.....I dontknw if it works here or not...

For Sql database ..i cant say.....

Sumit

Author: Tony JOhn (Webmaster)

webmaster - AspSpider.NET

Posted Date: 11/7/2005

http://aspspider.org/manjaly

My Beta site

We do not allow ftp for the free web hosting.

Author: Fridthjof-G Eriksen

Posted Date: 11/17/2005

for sql: a simple full backup every 24 hours to a single file which is available in the filemanager.

a simple t-sql script that enumerates all user databases and performs the backup is quite easy to make (and schedule) (just use disk='//mypath/@dbname.bak' with init to ensure you dont just append.. and @dbname is of course a local param of type sysname/nvarchar(128))

you might also consider using SMO if you are using SMS or MOM or similar to admin your servers...

see http://www.sqldbatips.com/showarticle.asp?ID=37 for a easy article on using SMO.

I assume that you have local admin rights on all the sql servers, so this could very easily be automated.

As for ms access, i guess thats just a question of copying the file, yes?

if you want some coding samples, let me know :)

Author: Andy Nguyen

Posted Date: 1/1/2006

/tanonev

alpha/ - Free Online RPG

http://www.aspheute.com/english/20011115.asp

It would be nice to just be able to backup the entire site in 1 zip file, possibly as a user-initiated event, as in 1asphost's file manager.
Also, this could be used to automatically unzip files we upload *cough cough*

Author: Andy Nguyen

Posted Date: 1/1/2006

/tanonev

alpha/ - Free Online RPG

whoops, the link was messed up

http://www.aspheute.com/english/20011115.asp

Author: jeff howard

northern state university

Posted Date: 1/5/2007

Please give us EXACT specifications for SQL that is installed on your server----SQL that creates the .bak files. This way when we go to restore out .bak files after downloading the zip file we know exactly whey we are getting errors (e.g. SQL serrver 2000 creates the .bak and I use SQL Server 2005 to try to restore it). Backups are worthless if one can't restore them..... result is the same as not having a backup.

You must login to post answer for this question.