May 26, 2008 at 4:11 am
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
May 26, 2008 at 4:53 am
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
May 26, 2008 at 10:21 am
u can also use the maintenance plan to do so..
..>>..
MobashA
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply