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 question: SQL 7.5 vs. SQL 2000

Wondering if SQL 2000 offers any compression of logical backups vs. no software compression in SQL 7.5. I've been asked to evaluate a 3rd party tool that compresses SQL 7.5 backups nicely, but this tool does not allow concatenating all databases into a single logical device file. I'm thinking I won't recommend the tool if SQL 2000 does compression on the fly as we will be upgrading sometime over the next handful of months.

TIAwhat tool are you referring to? sqllitespeed? and why would you need to append to the device? so that when you really need it you can't find it or it became corrupt and you consequently cannot recover anything?

sql2k does not compress, but m$ adopted sqllitespeed just for that purpose, as well as because it offers encryption (something that everybody is concerned about nowadays)

backup history: 3d party vendor

Hello,
It seems that the system table [backupset] does *not* contain backups ma
de by our 3d party backup
tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent c
ontrolled Tasks...).
Is this true?
How can I query the backup history of the 3d party tool?
(SQL S. 2000)
Thank You
JoachimJoachim
Please refer to
backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
restorefilegroup, and restorehistory.
"Joachim Hofmann" <speicher@.freenet.de> wrote in message
news:4056CD31.45AC9D4B@.freenet.de...
> Hello,
> It seems that the system table [backupset] does *not* contain backups made[/co
lor]
by our 3d party backup
> tool (Veritas), but only backups made by the SQL Server tools (Q.A., Agent
controlled Tasks...).
> Is this true?
> How can I query the backup history of the 3d party tool?
> (SQL S. 2000)
> Thank You
> Joachim|||Uri Dimant wrote:
> Joachim
> Please refer to
> backupfile, backupmediafamily, backupmediaset, backupset, restorefile,
> restorefilegroup, and restorehistory.
Thanks, I think I found the jobs. What really confuses me: The columns with
"software" in their name
always contain 'Microsoft SQL Server', in spite of the backup was made by th
e 'Veritas' Tool.
i.e:
select distinct software_name
from backupmediaset
Joachim