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 |
|
jugo
Starting Member
4 Posts |
 Posted - 2004-07-20 : 02:44:41
|
| I have DB in SQL server 2000 with service pack 3.I try to backup database on netwrok and if on computer is installed win 2000 it work good but i try same thing to do from win 2003 server and it says that "backup is done sucesfully" but on network comp is nothing backup there is no backup file.Can someone help me if knows why network backup don't work under win 2003 server?ThanksJugo |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-07-20 : 05:44:19
|
| Don't take a n/w backup. Take the backup on the local server, subsequently copy the file on the n/w.------------------------I think, therefore I am |
 |
|
|
jugo
Starting Member
4 Posts |
Posted - 2004-07-20 : 06:56:50
|
| But i relly need to do auto backup in jobs every day on another comp on net. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-07-20 : 08:10:18
|
| Use the job to create a daily backup on the local server. Then you can use the windows scheduler to copy this backup file to the n/w.Also you can use AT command of DOS.------------------------I think, therefore I am |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-20 : 08:50:30
|
| Have you figured out where the backup "went"??? You're not using a mapped network drive are you (for example J:\ that maps to \\server\share\)?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-20 : 12:28:23
|
quote:
Originally posted by jugo
But i relly need to do auto backup in jobs every day on another comp on net.
This can be done but is not recommended. It is recommended that you backup to the local disk first then copy the file to the remote server. This can all be done in a job so that it is automated.Tara |
|
|
|
|
|
|
Backup problem