SQL Server backup issue

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

---

Try running the Maintenance Plan wizard, to set up a nightly backup.

Later, read about backups in Books Online and Paul Randal's blog.

---

You'll need to add a job to the SQL Server Agent, it's in your object explorer when you log on with MSSMS.

But I think it's better to ask this on serverfault.com

---

If you want to run backup nightly you most likely using the computer account instead of a domain user account. So you might need to login and connect with the network service account (if for remote server db backup) by using the computer account instead of a domain user. To enable backups from specific computers to a shared drive, grant access to the computer accounts. Read more here.