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 - 2004-05-06 : 09:44:40
|
| ibrahim kutluay writes "Hello Sql Team Members.Im working at a company group. We have two different network. Two server and two sql server. SO i dont want to spend my all day with backup the data...By the way im searching easy and secure way for backup datas... currently im using enterprise manager and then zipping and write that zipped file to cd.. This is waste of time i think.. Did you know a way or a third party tool (any software)that backup files and sql databases without exporting it.... If you know any software it must also has other backup capabilites. (i mean backup documents other network users files etc) Thank you for time..." |
|
|
tonyshukal
Starting Member
7 Posts |
Posted - 2004-05-06 : 11:23:09
|
| There is no need for any 3rd party tool for this.You can make Job to run at specific time on specific days which will backup the required databases in particular directory and zip them for you.This writing on CD would be an mannual process. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-06 : 14:41:30
|
| Make a stored proced that does this and schedule it like tony said. You can use EXEC master..xp_cmdshell to zip the backup files and copy them to tape. Put everything in one stored procedure and schedule it during your maintenance window.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
backup sql server with single click