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 |
|
Camper66
Starting Member
13 Posts |
 Posted - 2008-08-01 : 08:53:08
|
| Hi,I know how to create a maintenance plan. However, when choosing a location to place the backup in, it seems I am restricted to the server locations on this computer. I can not target another computer on the network or to target a memory stick on this computer either, why ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-01 : 09:35:23
|
| Yes you can . Put \\Hostname\.... in backup location. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-08-01 : 09:41:27
|
| Maintenance plans look for local drives. To use a remote server, use UNC paths. Be sure that you have rights to the shared location (whatever account is running the Agent). At a minimum, you'll need write privileges and if you have a cleanup plan, delete rights as well.Terry |
|
|
|
Camper66
Starting Member
13 Posts |
Posted - 2008-08-01 : 10:03:55
|
| Tanks Sodeep and Tosscrosby, Pardon my ignorance, but how do I add \\Hostname\..to a device it does not see ? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-02 : 14:33:29
|
| Just type in. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-04 : 02:12:09
|
| it is a better thing to take the backups in the local system and copy the files with a batch file program to another server. so that there should be less burden on server.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
Back up question please