April 2, 2008 at 3:04 am
sql server 2000
os - windows 2000 server
1. i would like to know what is the difference when you take the backup using maintenance plan and using backup device (backups are first taken to disks and then to tapes).which is better? configuring it through maintenance plan or using device.
2. what is the difference between append to media and over writing exisiting media. which should be used and in which case.
3. waht is the advantages of using with init /noinit clause while doing a transaction log backup
i have seen a configuration like
( a ) BACKUP LOG [XXX] TO [XXXDmp] WITH NOINIT, NOUNLOAD,
NAME = N'XXX Trans Log Recurring Backup', NOSKIP, STATS = 10, NOFORMAT
(b) BACKUP LOG [XXX] TO [XXXDmp] WITH INIT , NOUNLOAD,
NAME = N'CompSjP backup', NOSKIP , STATS = 10, NOFORMAT
in case of a crash can i recover my d/b if i use the logback taken using the with init clause ? i think i will be able to recover my d/b using the log backup that has been taken using the no init clause
April 2, 2008 at 3:38 am
INIT will overwrite the existing backups in the set. NOINIT will preserver the exisiting backups.
GO to url ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm in Books OnLine (BOL) the SQL Server help files for information on the BACKUP LOG statement.
Maintenance plans are a wizard approach to make it easy to carry out basic administration. Much more flexible approach is to use TSQL. It takes time to learn what you need to know but you can be more confident in what you are doing when you understand what you are doing!
Regards
Nigel Moore
======================
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply