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 |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2004-09-27 : 02:58:33
|
| Hi, I want to schedule the database entire object script backup to keep a track of it... Through which process Can I take the object script backup... Can any body will help me on this... Thanks in Advance...-Mohit |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-27 : 03:02:43
|
| not sure i understand your question but here goes...create a job for the backup process and schedule it, include a step that will provide you the monitoring part, like an emailing system (search the forums for more info, this has been posted before)if you're looking for the backup script, search BOL for backup and restore... |
 |
|
|
mohit_sharan
Starting Member
22 Posts |
Posted - 2004-09-27 : 03:06:16
|
| I am looking for how to backup the database entire object script through command line... Not through GUI... As I had schedule the same... |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-27 : 03:17:05
|
you can create an exe file that accepts parameters like which database to backup, what type of backup and where to backup...no gui, straightforward single line command  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-27 : 03:56:53
|
| http://www.nigelrivett.net/DMOScriptAllDatabases.htmlKristen |
|
|
|
|
|
|
Scheduling Database Object Script Backup...