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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-27 : 08:06:15
|
| chaguito writes "Hello all...I am pretty new to SQL to please bear with me. I have 2 different databases on different servers and I would like to know if there is a script to make backups of those DB's and how to put that script to work daily. The Enterprise Manager is pretty good but only lets me do weekly backups and the data of those 2 databases are very critical.For example: Server1 => DVHistDBServer2 => VCATThanks in advance!!!! =)Chaguito" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-27 : 08:07:58
|
| You certainly can use Enterprise Manager to schedule daily, hourly, even minute-by-minute backups. Once the backup job is created, right-click on it in EM and choose Properties. The Schedule tab will let you add or modify the frequency of backups to whatever interval you like. |
 |
|
|
|
|
|
Automated SQL backup of single DB