are you using local accounts or ad logins?

the procedures are defining the names of local and remote sql server instances but for remote servers you will use sp_addlinkedserver these days

hello,

sounds to me like you should use sp_helpserver to see if the name matches the physical computer name and change it if needed with sp_dropserver and sp_addserver restart sql...

i dont know of any gui based installation to create the ini file in sql server 2005 but see the template.ini on the installation disc there is all the info...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: pryder

-- Create date:

-- Description: ...

sorry it doesnt 🙁 still in the data center but will drive back to work soon to see it on sql server

try it without paramvalues.

INSERT INTO Child (ParentID,name)

SELECT @NewID, ID.value('.','VARCHAR(20)')

FROM @bings.nodes('bings/group') as ParamValues(ID)

INSERT INTO Child (ParentID,name)

SELECT @NewID, ParamValues.ID.value('.','VARCHAR(MAX)')

FROM @bings.nodes('bings/group') as ParamValues(ID)

should fix this

or/and turn on the detailed logging if this allready is supposed to be your maintenance plan logfile

could you check or post the log file of the maintenance plan this would help with finding the error.

simon.letts (5/9/2008)

---

Hi, I found (?!) a bit of code to email me a report in html format. Have played around with it and all seems fine apart from the...

Are trying to set it up in the SSMS of SQL 2005? This would fail with the error you have to use the stored procedures in SQL 7 to set...

If you want both databases to be available you can not choose mirroring anyway. For distance you can pick mirroring but i would not set it up for high safety.

the log shipping will restore a backup on the secondary server while the replication does kind of a real time replication of the changes on your primary server.

Does your service account has write permission to the c:\ root? Try to backup to the default backup folder and not to the root of the drive.