Jayanth_Kurup (7/7/2011)

---

Since your using 64 bit SQL Server you actually do not need to enable lock pages in memory to avoid paging , mainly since sql will be able to...

3) be VERY careful using locked pages. you can wind up with a complete server hang, which is much worse than getting a bpool flush. See here for...

@Forum Newbie - we have both been saying that. Pls read our replies, we are not making it up.

the log backups are copied over. They are then restored from a local directory. Restores do not fail because of network outages. If a copy fails due to a network...

server is usually only started in single user mode to restore the master database, are you doing that currently?

any messages in the sqlagent errorlog or eventvwr?

backing up across a network will always be slow. Obvious speed up is to backup to local disk and then copy off to the SATA drive later.

what backup system is it currently?

Pls confirm the SQL version is in fact SQL2005.

lilywhites (7/7/2011)

---

thats what i was looking for!!! surprising i havent been able to find that states anywhere until now!!

i will look into making changes to stop tlog backups during the...

there's no point in time recovery with differentials , its just to the end of the differential, so thats your recovery point.

If you want to recover to a point in...

the undo file is only required in logshipping where the secondary database is restored in the read only, standby mode

2 yr old thread and an unrelated issue. Please post a new topic you will get more answers. Post the error in the sqlagent errorlog

from msdn

A data or differential backup contains sufficient transaction log records to allow rolling forward the active transactions as part of restoring each backup. Each backup also contain sufficient log...

lilywhites (7/6/2011)

---

Hello,

After examining a database corruption and restore scenario i have questions about the backup chain.

If we started a diff backup on a database this will only backup the altered...

from msdn:

'File containing information regarding any modifications that were made as part of incomplete transactions at the time the backup was performed. A transaction undo file is required if a...