Backup - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Backup

Author

Topic

Skullcrusher1907
Starting Member

5 Posts

Posted - 2009-10-13 : 11:59:06

I'm a newbie and I'm starting to use SQL Management Studio Expres 2005.
In the command "backup database", option WITH: which is the difference between the options FORMAT and INIT?

Thank you very much

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-13 : 12:03:33

The answer would bring up many more questions about tapes, media sets and and and.

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

No, you're never too old to Yak'n'Roll if you're too young to die.

Skullcrusher1907
Starting Member

5 Posts

Posted - 2009-10-13 : 12:14:15

Thank you
Great link

asgast
Posting Yak Master

149 Posts

Posted - 2009-10-13 : 12:14:25

:)
very scary question :)

Can't fall asleep, the ghost of sql server will get me for writing bad queries. Have to stay awake ...

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-13 : 12:23:26

[code]ONE...TWO...FREDDY'S COMING FOR YOU.
THREE...FOUR...BETTER LOCK YOUR DOOR.
FIVE...SIX...GRAB YOU CRUCIFIX.
SEVEN...EIGHT...GONNA STAY UP LATE.
NINE...TEN...NEVER SLEEP AGAIN! [/code]

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources