|
-
Aug 31st, 2005, 06:40 AM
#6
Re: SQL Server backups
 Originally Posted by ober0330
Well, thanks for that, but I think I'm just going to stick another hard drive in the SQL Server PC and just do backups to that instead. That way I can avoid the issues of network traffic, network problems, and keeping track of everything. I'll just let the SQL server handle everything.
Thanks anyways.
I'm using xp_cmdshell with robocopy.exe to copy new files in the backup folder to a network drive, or in your case to another drive.
exec xp_cmdshell '"d:\mssql\mssql\jobs\robocopy.exe f:\mssql\backup\ \\someserver\someshare\somefolder\ /XO"'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|