shedule to take the backup

Question

Post reply

shedule to take the backup

SAT_SQL

Default port

Points: 1465
More actions
June 13, 2009 at 1:07 am

#205954

Hi all
As i am new to SQL, i need to take the backup for four times in a day, as per this what i have to do , any links , how can i shedule ...
Regards
sat

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Also Read BOL (Books Online) for details.

Pradeep Singh

oded.raz Old Hand Points: 315 More actions · Answer 2

You maintenance plan to run backups, there you can specify the interval of the backups.

Oded

www.dbsnaps.com

www.orbiumsoftware.com

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

I recommend figuring out your backup and recovery stategy before creating the backups themselves. See BOL http://msdn.microsoft.com/en-us/library/ms191239(SQL.90).aspx

Greg

SAT_SQL Default port Points: 1465 More actions · Answer 4

Hi all

i can sechudule the back up for sql server 2005, but i can t.

but in my local server , i have sql 2005, & sql 2008 ,

is that make any difference in the same .

regard

sat

ps. One Orange Chip Points: 29422 More actions · Answer 5

i dont think i understand ur last post properly but what is the error u're getting in creating a maintainance plan for backup? or writing a plain job with backup query as a part of job?

Also i hope you have a backup strategy in place as pointed out rightly by Greg.

Pradeep Singh

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 6

Are you sure you have the right permissions on the SQL instance(s)?