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 - 2006-09-01 : 06:56:09
|
| Hi Team, A small doubt, Can we able to get connected to SQL SERVER for DOS prompt and execute the sql server cmd(s). Can we do that. I need this because i am trying to batch file which is scheduled at early morning 2:00 am so that it connects to SQL SERVER database and takes the backup to the specified backup dir.Because in oracle i used to do like that to take schema level bkps.I used to write bacth files and schedule them.But here in SQL SERVER 2000 how to do that.Can anyone help me plz.Regards,frank |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-01 : 06:58:30
|
| Have a lok at osql.You would probably be better off scheduling a backup via the sql server agent though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2006-09-01 : 07:00:08
|
| I know but i wanted to try it in a different way. Can u help me out.Best RegardsFrank |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-01 : 08:43:29
|
| Did you look at osql. It's a command line utility to enable you to run sql against sql server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
write a batch file which connects to sql servr.