Viewing 2 posts - 1 through 2 (of 2 total)
Just make sure the user name under which you perform this task, has permissions to copy and paste on both servers, or simply that this user name has local admin...
October 27, 2009 at 3:57 pm
#1071494
Try this:
declare @cmd varchar(256)
declare @backupfilename varchar (256)
set @backupfilename = 'database_backup.bak' -- set to the name of your backup file
set @cmd = 'Copy /Y C:\Backups' -- set to where your...
October 27, 2009 at 3:48 pm
#1071486