05-04-2007 11:07 AM
If the copy method acts the same as the Full, except that it does not truncate the logs, that would mean that the Full job does truncate the logs.
This section of the Admin guide seems to imply that they are two different jobs.
To make sure SQL is completely protected, back up the following on a
regular basis:
◆ The system drive that SQL is on.
◆ The Windows registry and System State.
◆ SQL databases or filegroups. You do not need to back up both.
◆ Transaction logs.
This sounds like the trans log should be backed up separately from the databases. Or, is this just a generic description of what tasks should be performed?
I only need to be able to restore a DB to the state is was during the previous nights backup. No need for point on time restores.
TIA
Message Edited by Adam Stern on 05-04-200711:30 AM
Message Edited by Adam Stern on 05-04-200711:31 AM (formats all messed, sorry)
Message Edited by Adam Stern on 05-04-200711:32 AM
05-07-2007 10:40 AM
05-07-2007 10:55 AM