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 |
|
Davids_Maguire
Starting Member
14 Posts |
 Posted - 2007-01-10 : 05:54:59
|
| hi all, this is my first post here in this forum , hope to find help. I need a way to force sql server to make backup of my database every specific period (every weak for example).Thanks in Advance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-10 : 06:33:26
|
| You can schedule your backups to occur at specific intervals using EM or through T-SQL. See BOL for details on how to do it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-10 : 06:42:26
|
| Hi... welcome to the forum. There are many ways to do thisthese are few(a) Create a maintenence plan and define all the backup and all other stuff there schedule it to run weekly(b) Create a Job which is scheduled to run in every week and in the setp include the backup script.Read Automated Administration How-to Topics in BOL (Books Online)Madhu |
|
|
|
|
|
|
DataBase Backup ...