Free asp.net web hosting Advertise with us

Login         Members       Shared Hosting   |                       Upgrade   |   Advertise   |   Tutorials   |  

Home » Questions & Answers » Backup policy - suggestions welcome





Backup policy - suggestions welcome

05 Nov, 05


Author: Tony John (Webmaster)
Webmaster - AspSpider.com
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: 07 Nov, 05   
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.com

Posted Date: 07 Nov, 05    		http://aspspider.org/manjaly

My Beta site
We do not allow ftp for the free web hosting.
Author: Fridthjof-G Eriksen

Posted Date: 17 Nov, 05   
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: 01 Jan, 06    		/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: 01 Jan, 06    		/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: 05 Jan, 07    		http://aspspider.ws/jazjef

Test asp.net page
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.



 











Total members: 250583
Average new registrations per day (in last 7 days): 11


New Registration: Open

Register Now




Talk to Webmaster
Tony John

Facebook
Google+
Twitter


Advertise   Privacy Policy   Terms of use   Contact Us

SpiderWorks Technologies Pvt Ltd.
All Rights Reserved.