How do I periodically backup up database in SQL 2008
Hi,
I am running on an SQL2008 Server and I would like to take a differential backup of my databases each night a midnight.
How do I do that?
thanks,
Chris Schene
I am running on an SQL2008 Server and I would like to take a differential backup of my databases each night a midnight.
How do I do that?
thanks,
Chris Schene
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sjwales: I did set up a backup as you suggested but it does not seem to be fully functional
It says the back should run, but I don't see the backup file in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER
I have attached a screen snapshot: any ideas?
db-scheduled-backup.png
It says the back should run, but I don't see the backup file in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER
I have attached a screen snapshot: any ideas?
db-scheduled-backup.png
See the bottom line on the left that says SQL Server Agent ?
It has a red stop sign over it.
Your SQL Server Agent isn't running (it is what runs the Maintenance Plan jobs).
Right click on SQL Server Agent and select start.
Wait till the top of the next hour and it should run. To see if the job runs, you can invoke it manually too. Start the Agent, expand the tree, expand jobs, right click on the job and select "Start Job at Step.."
It has a red stop sign over it.
Your SQL Server Agent isn't running (it is what runs the Maintenance Plan jobs).
Right click on SQL Server Agent and select start.
Wait till the top of the next hour and it should run. To see if the job runs, you can invoke it manually too. Start the Agent, expand the tree, expand jobs, right click on the job and select "Start Job at Step.."
check out this link.
http://storegrid.vembu.com