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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Database Backup

Author  Topic 

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-01 : 02:18:54
hi,
can anybody tel me how to use windows 7 task scheduler for backingup database and make it run automaticaly

Kristen
Test

22859 Posts

Posted - 2010-12-01 : 04:11:30
Use SQL Agent instead. That has scheduler and will run SQL commands / jobs.
Go to Top of Page

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-01 : 04:46:06
You could use sqlcmd to execute a backup statement - but as Kristen says ....

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-01 : 05:04:15
ok.but v dnt have sql agent in express
Go to Top of Page

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-01 : 05:17:04
There is a solution to use the broker to schedule jobs in express - do a search.
But using sqlcmd from the windows scheduler should work.

something like
sqlcmd -Smyserver -E -Q"backup database mydb to disk='c:\mydb.bak'"

oops - was sqlcmd available for v2005?
osql was very similar and was replaced by sqlcmd.


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-01 : 05:28:51
i wrote sp to take back up but dn5 knw how to use it to schedule in task schedule
Go to Top of Page

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-01 : 05:41:11
Use sqlcmd or osql to call it
I've checked and sqlcmd was available in v2005 so
sqlcmd -Smyserver -E -Q"exec mydb..s_MyBackup"

The -E means to use a trusted connection. It may need to be changed to a sql server connection depending on how the windows scheduler uns it but that's easy to set up.



==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2010-12-01 : 06:07:34
K thanks i will seethis
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-12-01 : 09:54:42
"but v dnt have sql agent in express"

Not included as standard, but available to download AFAIK. **much** easier than trying to do it from Windows Task Manager
Go to Top of Page
   

- Advertisement -