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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Maintenance Plan

Author  Topic 

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-02-01 : 07:11:38
Hi All,
As a part of creating a maintenance plan i want to copy the backfiles from the server to another machine.How can i achieve this .Please help its very urgent.



Thanks in Advance


RKNAIR

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-01 : 09:00:42

In the maintenance plan, Put in the network share:\\servername\folder for the backup ,it will directly copy to other server but the network banwidth should be good.
Go to Top of Page

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-02-01 : 09:57:11
I gave like that but the other machine is not in the same domain .

RKNAIR
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-01 : 11:00:54
Then make sure you have permission for that domain and copy the backup files.
Go to Top of Page

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2008-02-01 : 12:17:25
Created a seperate user and tried,but no use.The user have all rights still and not able to copy the files.

RKNAIR
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-01 : 23:28:25
You can copy file with windows task.
Go to Top of Page
   

- Advertisement -