I am exSybase (dont ask, I wont admit it again) and I would try the following:

1. Have you called Sybase Tech support (1 800 Sybase8&nbsp . ...

In 2005 SQL Server Management Studio, Object Explorer the Log Shipping setup is easy. 

Click on your databse and 

• Open database properties
• Click the Trasaction Log Shipping
• look for the checkbox Enable this as...

I would highly recommend putting the primary key to a logical key ( datatype int) especially if the abc columns are longer than 10 bytes.

Second do some analysis on...

Are you getting the error from your primary or log ship machine?

I found that both machines had to be setup with identical security to get log shipping to work.  Both of my...

I have run into several errors on databases that I upgraded.   The databases with the problems were all in '80' compatibility mode and didnt work with the standard reports. 

Hope that this...

One other thing to remember is have the machine ordered with a large enough C drive.  Our standard configuration was a tiny C drive and spending the cash on the...

The set showplan_all on command was exactly what I was looking for.

I completely forgot about that one....

Thanks again

Eric Peterson

What to do about SQL Error Reporting when the agent or SQL Server is down?

I tried a number of ways to solve this and found a third party product that...

Yes, this issue has been extensivly discussed in the forum over the past week.

Just wondering how Microsoft let this one slip thru?

I take the database offline when I want to copy the file and have the rest of my SQL Server functional.  I have also detached the database and Shut down...

I have tried stopping the server and taking the database offline so I can copy the database files. 

The new attach of the database says the database cannot be used...

I know that with log shipping, you cannot add users to the secondary database that do not exist in the primary databse . 

Just Wondering? Can you add users that are...

The following approach is a simple approach.....although if I had more time I would insert the results into a temp table then select * where the count = 0 (null) or...

I run the following query on a daily basis and store the information into a DatabaseFileUsage Table.  

I then export the data to excell and track file sizes...

Was your SQL Server (or all other SQL services like agent, browser...)  running at the time?  

Have you tried it with all of the SQL services turned off?

EP