October 3, 2001 at 5:24 am
Hi all,
How do I take a SQL backup from EM to a remote machine?
Is it enough if we give the remote server's name and shared folder? Lile \\server1\shared1\sqlbackup?
Kindly clarify
Parasu Raman
Regards
Parasu Raman
October 3, 2001 at 6:36 am
Nope. Do it as a two step process, back up to local disk, then use a batch file to move to other matchine.
Andy
October 3, 2001 at 6:41 am
Thanx Andy
Parasu Raman
Regards
Parasu Raman
October 3, 2001 at 7:16 am
One more thing.
How do I schedule my .bat file to be executed at a given time in a day?
Is there any tool that comes with my Win2K server?
Thanx
Parasu Raman
Regards
Parasu Raman
October 3, 2001 at 7:35 am
Try this in a SQL Job;
xp_cmdshell '\\yourserver\drive:\path\test.bat'
You may even want to build in (either in your .bat file or in SQL) a little rename script so that you can keep multiple copies of dumps on the server without overwriting the previous copy. Just one thought on how to do this.
Keep in mind that the size of the file you are copying with the .bat will determine how long the SQL job runs so, if that is a concern, you may want to consider other options.
Oh yeah, use a zip product and compress the file if it is large. Save time.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 3, 2001 at 8:58 am
You can use the Scheduled Tasks feature of Win - look under Accessories, System Tools, Scheduled Tasks. Zipping is not a bad idea, but you have to consider both the time it takes to zip and the associated load it puts on the box versus just copying it over.
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply