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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2007-03-12 : 00:49:38
|
| Hi pals, If you dont mind i need the following scripts. I am new sql server Administration. Need a automated script which takes the backup of all databases in a secified dir say "e:\backups\".Need a script which asks for a database name to be restored and restores to a blank database .Need a script to extract ddl of table structures,indexes,stored procedures,triggers and other database objects.I am able to get it using Enterprise manager-->All tasks-->Export/Import options.But basically i want to write a widows batch file and try to schedule the backups for which i need to know how to take bkps at command line.Thanks in advance.Regards,franky |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-12 : 08:26:30
|
| "i want to write a widows batch file and try to schedule the backups"If you just want them to happen at a specific time then its probably better to use the SQL Server Agent scheduler - rather than a Batch file.If something else needs to trigger them, then maybe the batch file is the best route.Kristen |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2007-03-13 : 02:37:02
|
| Thanks man |
|
|
|
|
|
|
need some backup scripts