Backup Plan

[BobbaBuoy]

I am having a hard time setting up a backup plan for my sql server databases. Right now I create a copy of each database on another machine on the network once a day. Once a week I upload a MSAccess version to a remote site. Obviously there are huge amounts of potential data loss if a crash of some sort would occur locally.

My new plan is looking like this:

1) Run a complete database backup once a day

2) Run Transaction Log backups every hour

My questions are as follows:

1) What role does a "Backup Device" play in this process (I currently do everything through the Enterprise Manager interface)?

2) I am having a hard time scheduling mydatabase_complete.bak and mydatabase_trans.TRN at all. I get several errors.

3) I would like to run these backups on another network machine but am not seeing how to access "My Network Places" from the "Backup Database" utility in Enterprise Manager.

Any help in the form of answers or pointing me towards a useful resource for this process would be much appreciated!

Thanks in advance~


Bobba Buoy
Just trying to make sense of it all ...

 

[philhege]

1. The "backup device" is either a file or a tape backup device.

2. Hard to say without seeing the actual errors.

3. According to Books Online, you can simply type in the UNC path of the network location of your backup file. I tested this with some of my local DBs and it works just fine.

It'd be best for you to review the backup topics in BOL, especially "Backing Up and Restoring Databases".

HTH,



Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.