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)
 Copy to backup file

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-04-26 : 08:05:16
hi
i am using isp_backup store procedure to get the daily backup of database and this is work fine but i have copy the database file in network sharing folder to use
following cmd
EXEC master..xp_cmdshell 'D:\filename M:\foldernam'
M:\ is network folder to window2003
but their no copy this folder

thank

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-26 : 10:30:53
Does sql service startup account have permission to write file to m:\? Should use unc name instead of mapped drive.
Go to Top of Page

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-04-28 : 07:55:24
Thanks rmiao
it is work very well
Go to Top of Page
   

- Advertisement -