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 |
|
iwalkalone
Starting Member
1 Post |
 Posted - 2008-02-17 : 09:46:35
|
| hi guyz! i am ananda from BANGLADESH. i am totally new to SQL SERVER. my platform was oracle. lets cum 2 da point. i want to backup my database autometically e.g, at 8pm everyday i wanna back it up. wht can i do for this. is thr ne scheduling like tools? pls help me.thnx n regards<<<GIVE PEACE A CHANCE>>> |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-17 : 09:48:58
|
you can backup using command BACKUP DATABASE and schedule it via in SQL Agent via Enterprise Manager (SQL Server 2000) or SQL Server Management Studio (SQL Server 2005)
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
thehandsomecode
Yak Posting Veteran
51 Posts |
Posted - 2008-02-18 : 11:30:34
|
| Hello There.It is quite simple if you have sql management studio installed. Drill down to the management Tab on the left then right click on maintenance plans and hit new maintenance plan qizard. Its Pretty simple from there as it allows you to create a backup and also schedule it to run at specified times.Compnetsyslc |
|
|
|
toxicrainpx
Starting Member
8 Posts |
Posted - 2008-02-19 : 13:23:02
|
Are you using SQL Server or SQL Server EXPRESS??quote:
Originally posted by iwalkalone
hi guyz! i am ananda from BANGLADESH. i am totally new to SQL SERVER. my platform was oracle. lets cum 2 da point. i want to backup my database autometically e.g, at 8pm everyday i wanna back it up. wht can i do for this. is thr ne scheduling like tools? pls help me.thnx n regards<<<GIVE PEACE A CHANCE>>>
|
|
|
|
fyaqoob15
Starting Member
1 Post |
Posted - 2011-04-16 : 01:03:27
|
| Hello,I am working in Supermarket which open 9am to 12am, 7 daysI am new to SQL.I am using SQL Server 2000, and my issue is i want to unscheduled my auto backup.actually the problem starts one day when i come to my office i see there has only 300mb space remains in my driver where auto backup files are saved. and the last auto backup was done before 5 hours (it was set auto backup daily after 2 hours) so when space remains low the last backup file was done in 04:00am, sowhen i come tomorrow in office i delete old backup files, and thought that the auto backup schedule will be unscheduled so i were set schedule again. i do this 4 times in different days....now i see k my old auto backup setting has already working with 2 hours interval, but my new 4 schedules are getting problem, these 4 schedules make 2.25gb file daily on 8:00am (2.25 x 4 = 10 GB)with following names:POS_db_201104020800.BAKPOS_db_201104022000.BAKPOS_db_201104050800.BAKPOS_db_201104110800.BAK, and when i come office daily i see my drive remains in Mb's, i want to unscheduled these 4 auto backup schedules because these will getting problem on Sunday when i will not come to office.PLEASE SUGGEST ME WHAT TO DO,Thanks in AdvanceHave a good day, |
|
|
|
|
|
|
|
|
auto backup