Bacjup of Data

[celeron895]

Was wondering how people were dealing with the backup of the SQL Server database. We would like to backup the data on a nightly basis to a remote location over our network. Has anyone dealt with this before?

 

[hooggie]

The typical way in which my customers perform SQL backups is to ren in SQL a scheduled task to backup the data each night using SQL backup. The loction can be specified.

They set the backup location to be a place on the network that is backup to tape using their network back up.

For more information on how to do a back up use the wizard in SQL it is failry pretty basic steps.

 

[celeron895]

We would like to back the data up to a remote location in order to have a working copy of the data at our development site. We have thought of replication, but it appears that replication adds an uniqueidentifier column to each table that does not have one. The backup and restore will not work as the backup file is over 1GB and would cause a real stain on our network.

 

[hooggie]

If you zip the backup file a 1GB Back up file should drop to 100 to 200MB and then shouldn't cause too much strain on your network.

a 1GB database would backup to a smaller file than a 1GB backup. Hopefully this would mean that you could zip the data down to around 100MB.

I don't know how you would automate that sorry