Monday, February 20, 2012

please help! log backups not being copied to destination server

sql2k sp3
*No domain accounts being used due to advice from
yesterday.*
Im trying to get Log Shipping going between 2 sql boxes.
The tlog backups arent being transferred to the
destination server. The primary box is in a domain and the
secondary is in a workgroup. As of this morning for the
purposes of this test, all sql services on both boxes are
running in local admin accounts that have the same name
and password. No domain accounts being used. After some
time the I get a red x because they are out of sync.
Nothing in the error log.
I can go into Query Analyzer logged in as the same account
that the services on both boxes are running in and copy a
file to the share without having to set up a linked server
login for him:
declare @.path varchar(200),
@.cmd varchar(200)
set @.cmd = 'copy C:\FIN\ds01
\SystemOnlyDBFiles\MSSQL\BACKUP\bla.txt '
set @.path = '\\backupsql1\BACKUP\bla.txt'
set @.cmd = @.cmd + @.path
exec master..xp_cmdshell @.cmd
Any ideas from anybody?
ThanksThe sql server agent on the destination server wasn't
running. I didnt realize it needed to be. Thanks to all
who may have been trying to figure it out.
Chris
>--Original Message--
>sql2k sp3
>*No domain accounts being used due to advice from
>yesterday.*
>Im trying to get Log Shipping going between 2 sql boxes.
>The tlog backups arent being transferred to the
>destination server. The primary box is in a domain and
the
>secondary is in a workgroup. As of this morning for the
>purposes of this test, all sql services on both boxes are
>running in local admin accounts that have the same name
>and password. No domain accounts being used. After some
>time the I get a red x because they are out of sync.
>Nothing in the error log.
>I can go into Query Analyzer logged in as the same
account
>that the services on both boxes are running in and copy a
>file to the share without having to set up a linked
server
>login for him:
>declare @.path varchar(200),
>@.cmd varchar(200)
>set @.cmd = 'copy C:\FIN\ds01
>\SystemOnlyDBFiles\MSSQL\BACKUP\bla.txt '
>set @.path = '\\backupsql1\BACKUP\bla.txt'
>set @.cmd = @.cmd + @.path
>exec master..xp_cmdshell @.cmd
>Any ideas from anybody?
>Thanks
>.
>

No comments:

Post a Comment