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.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2007-10-05 : 14:46:42
|
| Hello everyone,Is there a quick way to backup a given database via a query line?thankstony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-05 : 14:55:33
|
| Yes, check out BACKUP DATABASE command in BOL. Here's an example:BACKUP DATABASE Db1TO DISK = 'F:\Backup\Db1.BAK'WITH INITTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-10-05 : 16:22:24
|
| always a pleasure to be directed to the answer from you tara....the rest of you mugs....thanks for the infotake caretony |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-10-05 : 18:07:48
|
| You never heard about SQL Server Books Online before?CODO ERGO SUM |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-10-09 : 14:12:05
|
quote:
Originally posted by Michael Valentine Jones
You never heard about SQL Server Books Online before?CODO ERGO SUM
Thanks for that answer capt. obvioushttp://curezone.com/forums/troll.asp |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-10-09 : 14:29:25
|
| So, did you not know about SQL Server Books Online, or were you just too lazy to look up the answer?CODO ERGO SUM |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-10-09 : 14:30:05
|
| So are you calling MVJ a troll or admitting that you are a troll? I'm assuming the latter. |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-10-10 : 08:46:13
|
| LOLtroll one to know one |
|
|
|
|
|
|
Perform a backup from DTS job