One thing is certain, Manual intervention is needed to get a log shipped secondary server database up and running as the primary database.

Are you saying that you rebuild the indexes on your table and you get performance issues because of fragmentation?

Do you perform any bulk data loads after the indexes have been...

Redgate provide a free tool that i beleive you can use to read the log...but i think that may only be available on SQL Server 2000 there are others out...

You could try profiler and perf mon

I have a script that appends (INSERT INTO) records from a staging table to a production table that has many indexes on it. At the end of the script I...

Use the following script in SQL 2005 to check for orphaned users -

SELECT UserName = name

FROM sysusers

WHERE issqluser = 1

AND sid is...

Red gate have a SQL Doc tool that may help with your problem...

http://www.red-gate.com/products/SQL_Doc/index.htm

Does he have a login for the server in question? is it SQL Server or Windows...If its SQL Server login is the server security setting set to mixed mode?

i had this on 64bit servers in a few cases

solution was to enable lock pages in memory, not sure if you need to enable AWE and the rest on 32...

You need to restart:

SQL server instance service that relates to the instacne in question

You do not need to restart the other services

The service account that runs the SQL Server Agent...is that the same as the SQL Server Account? For the job to run successfully the users that runs the agent will...

Toni,

When you enable 'allow remote' connections you will need to stop and restart the SQL service for the changes to take affect. maybe a place to start.

Hope this helps

Gethyn

Hi Jim,

The account that runs the SQL Server Agent will need approiate permissions to run the job sucessfully. If not then it will fail.

Hope this helps

Gethyn

I assume you are using the Full recovery model?

why would you backup the log with truncate only? surely that renders the log useless and hence your ability to recover?

Do you...

If you want the database for read and write...i.e break th log shipping and your happy that the database is uptodate and correct then you can restore the database with...