NOINIT/INIT - defaults

is NOINIT the default for an install? can we change it to INIT instead.

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
reb73Connect With a Mentor Commented:
The default option is NOINIT, to override it just specify the INIT keyword using the WITH clause in the BACKUP DATABASE transact-sql statement..

Full Backup Database Transact-SQL reference is here -

http://msdn.microsoft.com/en-us/library/ms186865.aspx
0
 
anushahannaAuthor Commented:
for backups
0
 
anushahannaAuthor Commented:
in SSIS with the backup DB task, it does not give me option to edit NOINIT TO INIT. hence I was wondering if I can influence it from some other switch. any thoughts how to work around that?
0
 
anushahannaAuthor Commented:
thanks for the idea of sql task.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.