NOFORMAT AND NOINIT?

Question

NOFORMAT AND NOINIT?

sqlpanther

Ten Centuries

Points: 1204
More actions
May 26, 2010 at 12:59 pm

#223037

HELLO aLL CAN SOMEBODY BRIEFLY EXPLAIN ME WHAT IS NOFORMAT AND NOINIT? AND WHERE DO WE USE IT AND HOW?
THIANKS

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

I would suggest that you use Books On Line (BOL) and using the index feature search for each term ....I'll even give you another hint.... look at the T-SQL example for Backing up a data base.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

VastSQL SSC-Dedicated Points: 35970 More actions · Answer 2

NOFORMAT keeps the media header(default)

NOINIT options appends the backup to existing backup(default)

VastSQL SSC-Dedicated Points: 35970 More actions · Answer 3

Chechk this link

http://msdn.microsoft.com/en-us/library/ms186865.aspx

you can understand each and every options of a backup