Schedule the SQL Server Database Backup

Question

Schedule the SQL Server Database Backup

muhammad.hameed

Newbie

Points: 9
More actions
May 26, 2008 at 4:11 am

#190995

Actually i want to schedule the Backup of my SQL Server 2005 Database .
I want the Backup process will run automaticaly at some time and save the backup to the targeted location.
Waiting for reply.
Regards
Hameed

Viewing 3 posts - 1 through 2 (of 2 total)

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

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

If you are using a full version sql server use the sql server agent to schedule the backup.

If you are using sql express you will nt be able to use the sql server agent but you can easily schedule a backup usng the sqlcmd and the windows task scheduler.

A full treatment of how to backup sql server is given in BOL

http://technet.microsoft.com/en-gb/library/ms187048.aspx

or

http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx

mobasha SSCertifiable Points: 5334 More actions · Answer 2

u can also use the maintenance plan to do so..

..>>..

MobashA