Viewing 4 posts - 1 through 4 (of 4 total)
exec master..xp_cmdshell 'copy C:\file.txt \\servershare\file.txt'
xp_cmdshell allows you to run dos command prompts. If you are using 2005 you will need to check that this is enabled as it is...
April 24, 2008 at 9:30 am
Alternatively if you feel more comfortable using the GUI you can create a maintenance plan to backup databases which can have a step in it to determine how many days...
April 24, 2008 at 7:19 am
It depends on support arrangements in place between your company and theirs. If they insist on more than read / write access to the database and need sysadmin rights...
April 24, 2008 at 4:10 am
Viewing 4 posts - 1 through 4 (of 4 total)