Backing up Database(s) From Command Line 1

[PRUSA]

Hi,

I am new to SQL Server, and I know of maintenance plans beign able to backup databases.

I currently have some maintenance plans on some of my servers and on others we just rely on the network team beign able to backup all SQL Databases via ArchServe.

Well we've been having some problems with archserve, and I don't get notified until the next morning that the backups didnt' go through.

Is there a way I can run a database backup from command line?

I want to embedd that syntax in a .bat file.

Thanks in advance.

 

[vongrunt]

> I want to embedd that syntax in a .bat file.

Check osql utility and BACKUP DATABASE command topics in Books Online help.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[PRUSA]

Bingo!!

Thanks Vongrunt.
I appreciate the tip