Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Musak
Starting Member
1 Post |
 Posted - 2007-07-23 : 03:45:53
|
| Team,I have inherrited the position of our last DBA.I have a quick question,We have 2 jobs that run in regards to the Transaction Log.Job1. DUMP TRANSACTION "database" TO Device WITH NOUNLOAD , STATS = 10, NOINIT , NOSKIPJob2. DUMP TRANSACTION "database" TO Device WITH NOUNLOAD , STATS = 10, INIT , NOSKIPJob1 Runs during the day, hourlyJob2 Runs once a day, everyly in the morning.As far as i know, Noinit Appends to the backup Device, and Init overwrites the backup device.http://publib.boulder.ibm.com/infocenter/tivihelp/v15r1/index.jsp?topic=/com.ibm.itmfd.doc/main_sql161.htmINIT or NOINIT INIT means the backup overwrites any previous backup on the backup device. The media header is preserved. NOINIT means the backup is appended to the previous backup, if any. The default value is NOINIT. The backup does not overwrite if it encounters any of the following conditions:What does it mean by "The media header is preserved"Does this mean that, Job 2 (init) will add the lastnights transaction log to the begining of transaction log and then reinitialise the log?(lastnightsback)+(newlog)?Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-23 : 13:28:07
|
| Job2 just recreates log backup file and backs up log as first file in the device. |
 |
|
|
|
|
|
|
|
Init and NoInit