jeffwe,

What version of SQL Server, SAP, and who's SAN are you using ?

We are running SAP/R3, SQL7, on Seagate's XIOTech Magnitude for a year now with no issues. We...

Is any one using SLS, simple log shipping ?

We are using W2K Server(Not Adv), S2K Std Edt on a san, XioTech Magnitude by Seagate, with no issues. "Everything" is on the SAN.

We also have the data files...

I found the Simple log shipping version and was wondering if those that have used it have any lessons learned or suggestions from their experience.

I will also be converting from Sql 7 to 2000, but specifically from Ent. Edt. to Std. Edt. and have heard there are problems for this type of upgrade. ...

I was very excited about log shipping until I read it is available in Ent. Edt. only.

I only have Std. Edt., and was wondering if replication is my...

You didn't say what you were using to connect that fails. EM or QA ?

If EM is from a SQL 7 install, I believe you'll have to install...

Look at your SQL Server Properties via EM and click on the database settings tab. Towards the bottom you'll see the "Default data directory" and "Default log directory" settings....

Has anyone else had similar experiences?

I can only say that this has happened about a 1/2 dozen times over the past 5 months, and I do not think that the sp's have been the same...

The SQL Box has 512MB Ram. The OS is W2K with sp3 running SQL Server 2000 standard edition with sp2.

I had searched msdn KB in sql server 2000 for...

I don't believe that is TSQL Syntax. Try this in QA.

DECLARE @WORKPHONE AS NVARCHAR(12)

SELECT @WORKPHONE = '1234567890'

SELECT CASE LEN(@WORKPHONE)

WHEN 10 THEN

'(' + Left(@WORKPHONE,3) + ') ' +

substring(@WORKPHONE,4,3)...

When I clicked, All Tasks |Backup Database |Add |Backup device |<New Backup Device> and set Name: = Test and FileName = \\ky2095\c$\temp\backups\, I was able to backup successfully from the...

SELECT *

FROM Members

WHERE (EMAIL is NULL)

I'm not doing anything on par with outline, but from my sp's and I had to get around the transactions and nested sp's also.

I've added a @Return_Text parameter to sp's...