2575069
asked on
How to copy a windows file using sql server
i am using Quest litespeed to backup the databases in sql server to local drive.Is it
possible to copy the recent backup file from local drive to any network share drive using sql server.I tried with
xp_cmdshell command, but i am not sure how can i pick the latest file.
Thanks,
possible to copy the recent backup file from local drive to any network share drive using sql server.I tried with
xp_cmdshell command, but i am not sure how can i pick the latest file.
Thanks,
you can create backup file with datetime stamp while copying it, you can check that datetime and can decide, what to copy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.