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 |
|
gmax
Starting Member
3 Posts |
 Posted - 2005-06-14 : 21:08:01
|
I'm have SQL 2000 and I want to do a backup of a database over the network, but I just cant seem to find out how its done, please help I have run out of all options.Thanks, GMax |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-14 : 21:49:26
|
| http://weblogs.sqlteam.com/taradMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
gmax
Starting Member
3 Posts |
Posted - 2005-06-14 : 22:08:43
|
| I'm not sure what I'm looking at here |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-14 : 22:16:46
|
| She has a great backup script on her blog that will do backups over the network. She even commented the code and explained how they work.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
gmax
Starting Member
3 Posts |
Posted - 2005-06-15 : 00:43:45
|
| Is there any other way of doing this without using a script |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-15 : 08:59:28
|
| Oh crickety. What is wrong with using a script?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-15 : 09:04:27
|
| You can create a maintenance job via enterprise manager and path it to your network folder. But remember the path must be from the server’s point of view.JimUsers <> Logic |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-06-15 : 21:37:40
|
quote:
Is there any other way of doing this without using a script
How lazy can you get? She wrote the freaking script for you. It would take longer to create the stupid maintenance plan. Just paste the thing into a job and schedule it.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Database backups over a network