Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using SQL Server 2008 Enterprise on Windows Server 2008 x64. I want to run daily job at mid-night every day to make full backup of database. Any reference document to follow for a newbie of this topic?

thanks in advance, George

share|improve this question
add comment

2 Answers

I am NOT a great fan of maintenance plans in SQL Server and have heard of so many issues with them on the forums. If you are open to new ideas, have you looked into regular T-SQL scripts for managing the maintanence tasks instead of MP. Ola Hallengren has some excellent scripts and am currently using them in 3 of my servers and they work great. The quality of code is vouched by many SQL Server MVPs too. I know this offtopic on what you asked but wanted to throw in another option. You can find the scripts @ http://ola.hallengren.com/

Ola has created some documetation also on this and it will be easy for you.

share|improve this answer
add comment

What you want is a Maintenance Plan. Maintenance Plans in SQL Server can perform a variety of scheduled maintenance tasks for you on a schedule you specify. You can create a maintenance plan which will back up your databases using the Maintenance Plan Wizard in SQL Management Studio.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.