Under database options check to see if the truncate log on check point isn't set.

Do you any nonlogged updates? A DTS package moving a table or rebuilding a table?

John...

A full backup restored to the standby server is not needed unless there was some failure there. Just keep appling the next transaction log. Why not increase the frequency...

I disagree, If your looking for a dsiaster recovery model, then Log Shipping is is no brainer. Replication is an additional overhead on the Production server.

see discussion:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1333&FORUM_ID=5&CAT_ID=1&Topic_Title=Log+shipping+VS+Replication&Forum_Title=Administration

John Zacharkan

msdb..Sysjobhistory will tell you when a job completed.

You can see the job running by

select program_name from master..sysprocesses.

look in the results for something like...

Where is the job?

John Zacharkan

Steves' absolutely right, not sure where my head was before.

I like Raid 1 on my logs and backups. But I only recommend this if it's Hardware implemented. Don't...

If possible, suggest bouncing the server. I had the same bizzare situation yesterday. Agent is running but it's not, the only thing that cured it was a good bouncing....

What's the size of your log after the 5:30AM and 9:00AM loads, but before the backup hits? That should answer your question on how much space you need.

...

You really need to analyze and define your needs. If you have any thoughts of using the failover server for just that failover, then I would not consider it as...

ALTER DATABASE MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...). is a SQL 2K thing, not sure of how to do that in 7

John Zacharkan

If you can use BCP that would be an excellent choice.

If you need to do allot of data manipulation then control the data load through transactions. Sounds like your...

Many good ideas, depending on the one you take be mindful to check for any triggers.

And just the same I'd still take a backup, even if I have a...

Agree as well.

Case #1 is very clear as to what is running and when, no need to read documentation or figure out anything. Remeber KISS!

John Zacharkan

God I miss Cobol, try going from DMSII(hiearcle database) to EBCDIC flat file to tape to Ascii to SQL Server.!!!

Try this site http://www.rosetta-stone.co.uk They're the best in this...

Not being smart or anything but to answer your question:

select hostname from master.dbo.sysprocesses

Why is it stored in sysprocesses that way - That's a difficult question - Are you familiar with...