backup strategies for hosted enviroment ?

Im about to start a project that will be hosted by a third party web host. What is a common way to backup your database and have the backup saved ? The data may end up being several 100 MB of user settings, text etc (blog type stuff). If the DB gets to be several 100MB, then does making a backup and ftping it offsite sound reasonable ? Does ftp bandwidth usually count against your overall bandwidth usage ?

For FTP bandwidth going against your sites bandwidth... Ask your hoster - they'll tell you for sure.

For backing up, most hosts back everything up for you automatically (most of them do it daily).

What I've done in the past is every week or so I just take my DB offfline and copy it down to my computer using FTP. I then burn it. (not with fire)...

|||

Agree.

Make a backup and then ftp it to another place is the comman way. As to "make a back up every day or every week" , i would suggest you using sql server jobs. You can create a job and then schedule it run automatically every a certain time interval. You can refer to the following article to see how to create a backup job and make it run regularly:

To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:

1.Start SQL Server Management Studio.2.In theConnect to Server dialog box, click the appropriate values in theServer type list, in theServer name list, and in theAuthentication list.3.ClickConnect.4.In Object Explorer, expandDatabases.5.Right-click the database that you want to back up, clickTasks, and then clickBack Up.6.In theBack Up Database - DatabaseName dialog box, type the name of the backup set in theName box, and then clickAdd underDestination.7.In theSelect Backup Destination dialog box, type a path and a file name in theDestinations on disk box, and then clickOK.8.In theScript list, clickScript Action to Job.9.In theNew Job dialog box, clickSteps underSelect a page, and then clickEdit if you want to change the job parameters.

Note In theJob Step Properties - 1 dialog box, you can see the backup command.10.UnderSelect a page, clickSchedules, and then clickNew.11.In theNew Job Schedule dialog box, type the job name in theName box, specify the job schedule, and then clickOK.

Note If you want to configure alerts or notifications, you can clickAlerts orNotifications underSelect a page.12.ClickOK two times.

You receive the following message:

The backup of database 'DatabaseName' completed successfully.

Hope my suggestion helps

Backup SQL Database

The menu item "Backup SQL Database" does not appear as a
choice under Database Utilities when running an Access
2003 Project connected to an MSDE 2000 database on the
local machine. Why?
hi,
JBMoore wrote:
> The menu item "Backup SQL Database" does not appear as a
> choice under Database Utilities when running an Access
> 2003 Project connected to an MSDE 2000 database on the
> local machine. Why?
I've no particulary skill with Access, but the menu item is available to me
even when connected to a particular database with "public" role membership
only, as I thought that under circumstances of being member of
db_backupoperator database role at least was the reason of the menu item not
being shown... but is not the case.. ok the backup failed for insufficient
privileges :D:D
perhaps you've better post the question on Office NG...
sorry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Backup report file (.rdl)

Can I backup report files (.rdl) from reporting services server? and how to
do it?
Because my disk is broken, the report project also lost.
-_-...
thankshttp://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.getreportdefinition(SQL.90).aspx|||You can use Reporting Services Scripter to extract all the reports from your
Report Server.
Download here http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HC" <mcmssupereditor@.yahoo.com.hk> wrote in message
news:%23a60VIWWGHA.3848@.TK2MSFTNGP05.phx.gbl...
> Can I backup report files (.rdl) from reporting services server? and how
> to do it?
> Because my disk is broken, the report project also lost.
> -_-...
> thanks
>sql