Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bobbabuoy
Starting Member
33 Posts |
 Posted - 2006-08-13 : 12:58:35
|
| 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 day2) Run Transaction Log backups every hourMy 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~ |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-13 : 13:53:41
|
| Just schedule backup commands.Backup to a file and include the datetime in the filename.There is an SP that will backup all databases here (you can control it via a diask file.You can take the code to do the backups from the sp if you don't want it allhttp://www.nigelrivett.net/SQLAdmin/BackupAllDatabases.htmlIf you don't want it all it's easy to schedule the command for a sngle backup.http://www.nigelrivett.net/SQLAdmin/BackupDatabase.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Backup Plan