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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2009-12-01 : 04:35:40
|
| Hi everyone,I want to make schedule to take a backup for particular database on every monday at some specific time.I mean to say that, I have one DB named as CustomerInformationin my Sql server 2005,I want to shedule to take backup this DB on every monday at morning 8:00AMWhat should i do to schedule this backup automatically.Pleae help me out,Regards |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-12-01 : 04:43:45
|
| HiTry this...http://support.microsoft.com/kb/930615The above linkAllpies ToMicrosoft SQL Server 2005 Developer EditionMicrosoft SQL Server 2005 Enterprise EditionMicrosoft SQL Server 2005 Enterprise X64 EditionMicrosoft SQL Server 2005 Standard EditionMicrosoft SQL Server 2005 Standard X64 EditionMicrosoft SQL Server 2005 Workgroup Edition-------------------------R... |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-12-02 : 01:46:48
|
| You could set up a job and issue a "BACKUP DATABASE CustomerInformation to disk = MYDRIVE:\mydbbackupDDMMYY.bak". This would back it up to local disk.Then set the schedule to run this job at the designated timeFor something more reliable in a DR situation , you will have to consider moving the backup copy. There are alternative ways and many third party tools that can manage the scheduling and commands from a third serverJack Vamvas--------------------http://www.ITjobfeed.com (IT jobs) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
how can i take backup automatically.....